oracle - 立即执行多个更新

Question

我有几个必须动态执行的更新语句。我正在使用立即执行来执行这两个更新语句。但是，这样做时出现以下错误:

ORA-00911: invalid character
ORA-06512: at line 7
00911. 00000 -  "invalid character"
*Cause:    identifiers may not start with any ASCII character other than ..

在立即执行中是否有不能执行超过 1 个更新语句的限制？

编辑:例如:

begin 
EXECUTE IMMEDIATE 'UPDATE tt_TGT_TABLE SET PK_1 = ''Demand10'' where ROW_ID = 3923866 ; UPDATE tt_TGT_TABLE SET PK_1 = ''Demand11'' where ROW_ID = 3923868'; 
end;

Answer 1

您不能简单地在 EXECUTE IMMEDIATE 中连接多个语句。调用 - 您要么必须使用多个调用:

begin 
  EXECUTE IMMEDIATE 'UPDATE tt_TGT_TABLE SET PK_1 = ''Demand10'' where ROW_ID = 3923866';
  EXECUTE IMMEDIATE 'UPDATE tt_TGT_TABLE SET PK_1 = ''Demand11'' where ROW_ID = 3923868'; 
end;

或将匿名 PL/SQL 块输入 EXECUTE IMMEDIATE :

begin 
  EXECUTE IMMEDIATE '
    begin
      UPDATE tt_TGT_TABLE SET PK_1 = ''Demand10'' where ROW_ID = 3923866;
      UPDATE tt_TGT_TABLE SET PK_1 = ''Demand11'' where ROW_ID = 3923868;
    end;';   
end;