I am trying to execute an update query in a stored procedure. The problem is that the name of the column to be set is not settled but defined by a variable.


UPDATE TBL_TEST SET variable = value

I generate the query dynamically and put it in a string but now I do not know how to execute it.

All ideas is welcome.


Thanks is advance.

Manue

Hello,

if you have saved your build update statement ind a variable use :

EXECUTE IMMEDIATE variable;

where variable is the name of your variable ...

if you want to use bind vars instead use

EXECUTE IMMEDIATE 'UPDATE tab set :var = ':con'
USING var, con;

Hope that helps ?

Regards
Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.de

Which database are you using ?