Home » SQL & PL/SQL » SQL & PL/SQL » urgent..how do i return the resultset or cursor from oracle stored procedure
urgent..how do i return the resultset or cursor from oracle stored procedure [message #37230] Fri, 25 January 2002 05:15 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
I have a stored procedure.How do i return the resultset or cursor from the stored procedure.
In sqlserver we can just return the resultset.
How we can do in oracle.

ksri
Re: urgent..how do i return the resultset or cursor from oracle stored procedure [message #37231 is a reply to message #37230] Fri, 25 January 2002 05:30 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

use table of records .

cheers
pratap
Re: urgent..how do i return the resultset or cursor from oracle stored procedure [message #37235 is a reply to message #37230] Fri, 25 January 2002 08:35 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Deja vu...

You use a ref cursor to return a result set from a procedure. Here is a great link for this:

http://osi.oracle.com/~tkyte/ResultSets/index.html
Previous Topic: Execute Immediate
Next Topic: SQL* Plus 3.3
Goto Forum:
  


Current Time: Tue Apr 07 03:32:38 CDT 2020