O sys_refcursor;
R a, % rowtype.
The begin
The open o for the select * from a, where id=5.
Into the fetch o r;
If o % fount then
Insert into b (m) values (r.k);
end if;
The return o;
end; Does not return data, please advise
CodePudding user response:
How to call, put the statement,CodePudding user response:
Had better not performs an inset in the function such as operation, can bring a lot of trouble to your transaction processing