var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Execute an update query in a stored procedure
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.
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 ?
(Alligator Company GmbH)
Which database are you using ?