General discussion

Locked

Resultset in Oracle

By anandvp ·
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).

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Resultset in Oracle

by finluca In reply to Resultset in Oracle

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.

Back to Desktop Forum
1 total post (Page 1 of 1)  

Hardware Forums