-
multi row Stored Procedure
Hi,
Can i create stored procedure that returns a recordset without using cursors.
Regards
-
Yes, then you have to hardcode the values. I don't know why would you do that.
my_recordset(1).col1 := 1;
my_recordset(1).col2 := 'blahblahblah';
my_recordset(2).col1 := 2;
my_recordset(2).col2 := 'moreblahblahblah';
-
Sorry this is not what i meant.
I mean how to return the result of multi records select statment using stored procedure.
-
What's wrong with cursors?
You have to open ref cursor for a select statement to accomplish what you want. For that matter it is not a cursor but a cursor variable that points to a recordset described by the select statement for which you opened your ref cursor. Read about ref cursors they are pretty nifty thingamajigs.
d
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|