Getting Values in a Record Variable into a cursor [message #838] |
Thu, 07 March 2002 10:05 |
bwilliam
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
Thanks in advance for your help..
Using Oracle PL/SQL for 8i:
If I have a reference cursor variable (c) that is based on a certain Record Type. I can create a record variable that is the same record type and then FETCH data from the cursor into the Record Type variable. No problem.
However, what I need to know is whether there is a way to go the other way and put the values that are in a record variable into a cursor variable.
I tried things like:
OPEN c FOR
SELECT
vRecTemp
FROM Dual; where vRecTemp is the record variable that I am trying to get into the cursor.
But this causes an error of invalid datatype.
Any ideas on how I can get this data into the cursor?
Thanks
|
|
|
|