Using variable as column name in update statement
Posted on 2003-03-21
I have a procedure, with the following update statement,
update table1 set VARIABLE_NAME = 1 where id = 3
I get the error "virtual column not allowed here", and if I replace VARIABLE_NAME with the name of one of the columns, it works...
Is there any way to get Oracle to read this and get the VALUE for the VARIABLE_NAME, instead of reading it literally?
ps - this is inside a cursor loop, so it is only returning one variable_name result each time it hits the loop, in case anyone was wondering why I was using a variable here....
thanks in advance for any help!