PL/SQL errors in Oracle packages

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
-------- -----------------------------------------------------------------
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.

About Jim Vanderveen

I'm a bit of a Renaissance man, with far too many hobbies for my free time! But more important than any hobby is my family. My proudest accomplishment has been raising some great kids! And somehow convincing my wife to put up with me since 1988. ;)
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *