Stored Procedures that Return Result Sets

[shammack]

How does one write an Oracle stored procedure that returns a result set? Can anyone provide a brief example?

 

[rcurva]

You can make use of REFCURSOR in Oracle. I am sure there are white papers with examples out there. Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[jee]

See the PL/SQL User Guide for examples

(Available online at

http://otn.oracle.com/docs/products/oracle8i/content.html

if you don't have a hardcopy or an Oracle documentation CD).

 

[Guest_imported]

this is the simplest form of ref cursor.

variable x refcursor

begin
open :x for select * from emp;
end;
/

print x

 

[Guest_imported]

I should say, do this in sql*plus.