Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Variable table name in update command
I have a stored procedure that uses a cursor:
CURSOR ExtractCur IS
select remform, action_id, effdt...
from WorkingTable
order by effdt;
I then wish to update a record in a table based on the data in the cursor:
FOR c IN ExtractCur LOOP
...
update c.remform set status = 3 where action_id = c.action_id;
END LOOP;
but it trips on the compile - complaining that the table 'c.remform'
does not exist.
How can I use a variable for a tablename in an update command?
Received on Wed Sep 13 2006 - 10:54:51 CDT
![]() |
![]() |