OraFAQ Forum: SQL & PL/SQL » Stored procedure to return rows

Home » SQL & PL/SQL » SQL & PL/SQL » Stored procedure to return rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Stored procedure to return rows [message #36785]

Thu, 20 December 2001 10:28

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.

----------------------------------------------------------------------

Report message to a moderator

Re: Stored procedure to return rows [message #36789 is a reply to message #36785]

Thu, 20 December 2001 11:35

vk
Messages: 13
Registered: December 2001

Junior Member

use ref cursors to return record sets

----------------------------------------------------------------------

Report message to a moderator

Re: Stored procedure to return rows [message #36791 is a reply to message #36789]

Thu, 20 December 2001 17:28

diaz
Messages: 58
Registered: October 2001

Member

well, it'll still unclear for me..
can you give a little example ?
thanks

----------------------------------------------------------------------

Report message to a moderator

Re: Stored procedure to return rows [message #36825 is a reply to message #36789]

Mon, 24 December 2001 06:50

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

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	pl/sql cursors
Next Topic:	DDL trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 04:27:54 CDT 2026