Oracle-无法更改过程

Question

当DbUp执行以下SQL脚本时，我会得到一个错误，如下所示：

CREATE OR REPLACE PROCEDURE INVOICE_DELETE
(PAR_INVOICE_ID IN NUMBER)
AS 
BEGIN   
DELETE FROM INVOICE_SECT_ACCOUNTING_DATA
WHERE INVOICE_ID = PAR_INVOICE_ID;

DELETE FROM INVOICE
WHERE INVOICE_ID = PAR_INVOICE_ID;

COMMIT;

END INVOICE_DELETE;

Oracle错误代码：1；电话号码：2147467259；消息：904
Oracle。ManagedDataAccess。客户OracleException(0x80004005(：
ORA-00904:"PAR_INVOICE_识别码

Answer 1

DbUp Oracle有两个内置程序：OracleDatabaseWithDefaultDelimiter和OracleDatabaseWithSemiconDelimiter-https://github.com/DbUp/DbUp/pull/335.

我很糟糕，因为我使用了带有分号分隔符的OracleDatabase。所以DbUp将我的过程分解为多个部分。