Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

returning recordsets from stored proc

Status
Not open for further replies.
kallavigv

kallavigv

Programmer
Sep 15, 1999
1
US
HI,<br>
<br>
I want to create a stored proc in Oracle 8 which 'll return a recordset. <br>
Can somebody help me a sample code?.<br>

 
Sort by date Sort by votes
Use the REFERENCE CURSOR as the technique to return a record<br>
set. You simply have to define a record type as the structure of the record in the record set. Then use that new<br>
type in the query which captures the record set.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
422
Andrzejek
Andrzejek
mibeach7
  • Locked
  • Question
OEM extract ORA- from string text 1
Replies
2
Views
115
mibeach7
mibeach7
Andrzejek
  • Locked
  • Question
Copy a table from Test to Production
Replies
1
Views
100
carp
carp
LarrySteele
  • Locked
  • Question
Searching multiple fields for any/all words from a search string.
Replies
2
Views
104
LarrySteele
LarrySteele
hmckillop
  • Locked
  • Question
Exporting specific data from DB into another DB
Replies
1
Views
98
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top