ORA-06545: PL/SQL: compilation error – compilation aborted
Cause: A pl/sql compilation error occurred and the compilation was aborted completely without the compilation unit being written out to the backing store. Unlike ora-06541, the user will always see this error along with the accompaning PLS-nnnnn error messages.
Action: See accompanying PLS-nnnnn error messages.
ORA-06545是一个通用的PL/SQL编译错误,它表明在编译过程中发生了错误,程序只能在编译时中止。
官方解释
ORA-06545: PL/SQL: compilation error – compilation aborted
Cause: A compilation process terminated abnormally without a disposition message.
Action: Examine the listing file to determine the error. Within the PL/SQL block, encircled items indicate compile-time errors.
常见案例
通常,ORA-06545可能是由于在PL/SQL程序中出现语法错误,而无法编译程序而引起的:
DECLARE
int numbera ;
numberb int;
BEGIN
…
END;
正常处理方法及步骤
步骤1:停止当前的编译过程
步骤2:使用“LIST”或“LIST XX”命令检查程序代码中的任何错误,其中XX为错误发生处的行号
步骤3:在PL/SQL块中检查编译时出现的错误
步骤4:修改代码,重新运行程序
步骤5:重新编译PL/SQL程序