(1)實現delete沒有問題:
drop PROCEDURE testProced;
CREATE PROCEDURE testProced(
out out_name1 integer
)
LANGUAGE SQL
------------------------------------------------------------------------
-- SQL 存儲過程
------------------------------------------------------------------------
P1: BEGIN
declare MySQL varchar(20);
declare SCORE_tmp varchar(100);
set SCORE_tmp = "SCORE ";
set MySQL = "DELETE FROM T_USER WHERE " ¦ ¦SCORE_tmp ¦ ¦ "= " "2 " " ";
EXECUTE IMMEDIATE MySQL ;
COMMIT;
END P1
(2)select 就出現問題。
如何實現select a into b from table1 ,其中a、table1都是動態的。