Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Variable table name in update command

Variable table name in update command

From: drake <akeller_at_suncom.com>
Date: 13 Sep 2006 08:54:51 -0700
Message-ID: <1158162891.483558.99010@p79g2000cwp.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US