Ref cursor and PLSQL Table
561456Feb 22 2007 — edited Feb 23 2007I have data in a PLSQL table of records. How do I pass the contents in a ref cursor back to the calling environment which is Java.
Code is like this :
create procedure p (refcur IN OUT refcurType)
type rec is record (n number,
t varchar2(12).....
......
);
type tabtype is table of rec index by binary integer;
rectab tabtype;
is
begin
--calculate and store values in rectab
now need to pass out contents of rectab in ref cur.
end;
type refcur is ref cursor -- declared in global package.
Please help.