Something like create or replace procedure my_proc( p_rc OUT SYS_REFCURSOR ) as begin open p_rc for select 1 col1 from dual; end; / variable rc refcursor; exec my_proc( :rc ); print rc; will work in SQL*Plus or SQL Developer. I don’t have any experience with Embarcardero Rapid XE2 so I have no idea whether it … Read more
You sure can. There are a few gotchas to be wary of but here is a test case create or replace function testodpRefCursor( uniqueId IN NUMBER ,resultItems OUT NOCOPY SYS_REFCURSOR) RETURN NUMBER IS BEGIN OPEN resultItems for select level from dual connect by level < uniqueId ; return 1; END testodpRefCursor; I have found that … Read more
You can use a bind variable declared in SQL Developer to hold and show the results: var r refcursor; exec myPackage.mySPTest(P_NOTIFICATION_ID => 1975357, P_CURSOR => :r); print r; exec is shorthand for an anonymous block so this is equivalent to: var r refcursor; begin myPackage.mySPTest(P_NOTIFICATION_ID => 1975357, P_CURSOR => :r); end; / print r; Unless … Read more