Home » SQL & PL/SQL » SQL & PL/SQL » Stored procedure to return rows
Stored procedure to return rows [message #36785] Thu, 20 December 2001 10:28 Go to next message
Nilesh
Messages: 16
Registered: November 1999
Junior Member
I want to create a sp or function so that when called it should return a recordset. Something like what we do in SQL Server. Does anyone know how to do that in Oracle? Thank you in advance for you help.

----------------------------------------------------------------------
Re: Stored procedure to return rows [message #36789 is a reply to message #36785] Thu, 20 December 2001 11:35 Go to previous messageGo to next message
vk
Messages: 13
Registered: December 2001
Junior Member
use ref cursors to return record sets

----------------------------------------------------------------------
Re: Stored procedure to return rows [message #36791 is a reply to message #36789] Thu, 20 December 2001 17:28 Go to previous messageGo to next message
diaz
Messages: 58
Registered: October 2001
Member
well, it'll still unclear for me..
can you give a little example ?
thanks

----------------------------------------------------------------------
Re: Stored procedure to return rows [message #36825 is a reply to message #36789] Mon, 24 December 2001 06:50 Go to previous message
vk
Messages: 13
Registered: December 2001
Junior Member
Refer these:

http://technet.oracle.com/doc/server.815/a67842/05_ora.htm#4641

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q255043

http://www.learnasp.com/learn/oraclerecordsetsfromsp.asp

----------------------------------------------------------------------
Previous Topic: pl/sql cursors
Next Topic: DDL trigger
Goto Forum:
  


Current Time: Sun May 31 03:21:42 CDT 2020