multi row Stored Procedure
Can i create stored procedure that returns a recordset without using cursors.
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.
Click Here to Expand Forum to Full Width