I can never remember how to get a list of compiler errors from Oracle PL/SQL packages. It’s annoyingly simple, but I wish they would just show up in my SQL*Plus session without requiring me to remember the stupid command!
SQL> @ pmtalloc-pkg
Warning: Package created with compilation errors.
SQL> show errors
Errors for PACKAGE PMTALLOC:
LINE/COL ERROR
2/13 PLS-00103: Encountered the symbol “HERE” when expecting one of the following: := . ( @ % ; not null range renames default
The line and column numbers above may or may not be helpful, depending on how you format the SQL file.
This is version 7.1.3 of Oracle. (Yes, I’m aware that it’s incredibly outdated). I don’t know if they’ve done anything about this, but I doubt it. I don’t mess around with packages enough to have this little trick ingrained in my memory, but hopefully I’ll remember to search my own blog next time I have trouble with this.
