Tuesday, April 28, 2015

ORA-24344: success with compilation error

I have spent time recently working on some fairly lengthy Oracle PL/SQL scripts. The scripts are run via SQL*Plus (e.g. "SQL> @CreateOracle.sql"), and the main script references several other external scripts. One of the scripts creates a trigger on a table. The output shown in the log file is:

ORA-24344: success with compilation error 

However, by the time the rest of the scripts completed, SQL*Plus reported no errors on that trigger. It became a frustrating endeavor to try and find out what the actual compile error was. I finally had to remove all of the scripts that followed the failing script. With the failing script executing last, I was then able to use the USER_ERRORS view to see the actual compile errors (thanks to this post for the suggestion):

select * from user_errors

The actual error itself was very easy to fix ... once I was finally able to find it.

No comments:

Post a Comment