oracle 存储过程中查询结果无法赋值到变量，请指教
CREATE OR REPLACE PROCEDURE test1
IS
tmpVar NUMBER;
strSQL VARCHAR2 (2000);
BEGIN
strSQL := 'drop table test';
EXECUTE IMMEDIATE strSQL;
strSQL := 'CREATE TABLE DDCXD.test(bh NUMBER)';
EXECUTE IMMEDIATE strSQL;
strSQL := 'select count(*) from local_xx';
EXECUTE IMMEDIATE strSQL into tmpVar ;
strSQL := 'insert into test values(' || tmpVar || ')';
EXECUTE IMMEDIATE strSQL;
END test1;
最新回答
小阳光温暖我╮
2024-10-12 06:47:37
CREATE OR REPLACE PROCEDURE test1
IS
tmpVar NUMBER;
strSQL VARCHAR2 (2000);
BEGIN
strSQL := 'drop table test';
EXECUTE IMMEDIATE strSQL;
strSQL := 'CREATE TABLE DDCXD.test(bh NUMBER)';
EXECUTE IMMEDIATE strSQL;
strSQL := 'select count(*) from local_xx';
EXECUTE IMMEDIATE strSQL into tmpVar ;
strSQL := 'insert into test values(' || tmpVar || ')';
EXECUTE IMMEDIATE strSQL;
commit;
END test1;
这样就行了
热门标签
