java - statement.execute() 在 PL/SQL 末尾返回带有斜杠的错误

Question

执行pl/sql时报错:

ORA-06550: line 1, column 316: PLS-00103: Encountered the symbol "/" The symbol "/" was ignored. 

PLSQL 示例:

DECLARE
   SQL1   VARCHAR2 (1500);
   SQL2   VARCHAR2 (1500);
BEGIN
   SQL1   := 'INSERT INTO das_html_caption VALUES (''test_test'')';
   SQL2   := 'DELETE FROM das_html_caption where wording = ''test_test''';

   EXECUTE IMMEDIATE SQL2;

   EXECUTE IMMEDIATE SQL1;

   EXECUTE IMMEDIATE SQL2;

   COMMIT;
END;
/

Java:

Statement statement = dbConnection.createStatement();
ResultSet rs = null;
boolean ret = statement.execute( sql.getValue() );

是正确的错误吗？或者我做错了什么？

谢谢

Answer 1

斜杠是通过交互式环境(如 SQL*Plus)执行匿名 block 的方式。如果您通过 Java 调用执行此 block ，则不需要终止斜杠。