hi,

please see the below case. i have executed that function and it
updated the table without any errors and returned the value also.

create or replace function meena_test return varchar2
as
l_ename varchar2(10);
begin

update emp
set ename = 'cherum'
where empno = 101;

commit;

select ename
into l_ename
from emp
where ename = 'Meena';

return(l_ename);
end;
/
sho err