by meena cherukupalli <cherukupalli.meena@[EMAIL PROTECTED]
>
Apr 29, 2008 at 05:05 AM
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
