Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select values from table%ROWTYPE variable into a cursor

163745Sep 28 2005 — edited Sep 29 2005
I have a stored procedure which has an OUT parameter of table1%ROWTYPE.

In future we might have to add more OUT parameters of table2%ROWTYPE etc. But at any point of time only one will have values.

So instead of having table%ROWTYPE as OUT parameter, can I send these single row ( with variable values) in a cursor, so that declaration part atleast will not change.

Is it possible to select values from table%ROWTYPE variable into a cursor.

cursorOUT IS
SELECT * FROM varREC;

where varREC is table.ROWTYPE variable.

Or which is the better solution in this situation.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2005
Added on Sep 28 2005
2 comments
802 views