Home » SQL & PL/SQL » SQL & PL/SQL » Getting Values in a Record Variable into a cursor
Getting Values in a Record Variable into a cursor [message #838] Thu, 07 March 2002 10:05 Go to next message
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
Re: Getting Values in a Record Variable into a cursor [message #839 is a reply to message #838] Thu, 07 March 2002 10:55 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
http://www.orafaq.net/msgboard/plsql/messages/7407.htm
Previous Topic: is this possible
Next Topic: Database Triggers
Goto Forum:
  


Current Time: Tue Oct 19 20:35:32 CDT 2021