Discussion Locked

Resultset in Oracle

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do i return a return a resultset in Oracle's Stored Procedure which can hold multiple row's of data.(something like your cursor).

1 reply

by finluca

You can use a cursor variable. This is basically a pointer to a cursor and can be passed between programs as a parameter. PL/SQL has a type called REF CURSOR that is used to define the cursor variable. The cursor variable can then be used in the stored procedure just like a cursor that is defined in the stored procedure.

This discussion is closed to new replies.