Home » SQL & PL/SQL » SQL & PL/SQL » Multiple Record return [multi-merge]
Multiple Record return [multi-merge] [message #398334] Thu, 16 April 2009 01:16 Go to next message
rmpanda
Messages: 2
Registered: April 2009
Junior Member
In MS-Sql2000 I used to return the statement like
select * from atable, from the storeprocedure and capture it in the Crystal report.

But in Oracle10g is there any way to do that.
returning multiple rows from a SP.
Regards
Rama
Re: Multiple Record return [message #398337 is a reply to message #398334] Thu, 16 April 2009 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a REF CURSOR.

Regards
Michel
Re: Multiple Record return [message #398338 is a reply to message #398334] Thu, 16 April 2009 01:22 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Do not cross/multi-post
Multiple Record return [message #398391 is a reply to message #398334] Thu, 16 April 2009 02:42 Go to previous messageGo to next message
rmpanda
Messages: 2
Registered: April 2009
Junior Member
I used to write Select * from atable at the end of the SP in MSSQL2005 and capture it in the crystal report to show the fields in the report.

Is there any way to do the same in Oracle10g

Regards
Rama
Re: Multiple Record return [message #398398 is a reply to message #398391] Thu, 16 April 2009 02:48 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and REF CURSOR (see your previous topic).

Regards
Michel
Previous Topic: how to handle this - how to escape &
Next Topic: How to pass an array to an Procedure
Goto Forum:
  


Current Time: Wed Dec 07 03:19:54 CST 2016

Total time taken to generate the page: 0.05166 seconds