var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stored Procedures with Dynamic Select's Update's and Delete's
All examples i have seen about dynamic sql within stored procedures, isn't actually dynamic sql, its more like late binding since they pass arguments to look for...
What im looking for is something like passing the columns has arguments...
SELECT :Column1 :Column2 etc etc
How can i accomplish that in PL/SQL Stored Procedures or Java Stored Procedures.
Thx a lot.
Refer to IBM documentation about cursors to process result set but to get you started:
DECLARE v_sql varchar(1000);
DECLARE v_dynamic statement;
SET v_sql = 'SELECT ' || column1 || ', ' || column 2 || ' FROM sometable WHERE ....'
PREPARE v_dynamic FROM v_sql;