达梦数据库动态执行语句

 

CREATE OR REPLACE PROCEDURE "HNJKUSR"."SP_INSERT_DATA"
AS
/*变量说明部分*/
i INT;
runsql varchar2(32);
l_cnt number;
BEGIN
/*执行体*/
i:=1;
runsql='select count(1) from dual';
execute immediate runsql into l_cnt;
print('执行结果l_cnt='||l_cnt);
END;