Friday, 8 July 2011

Oracle - PL/SQL show errors

To check if a package or procedure is producing any errors, within SQLPLUS run the following command:
SQL> show error
If there are any errors then these will be listed along with line numbers. If there are no errors then the following will be displayed:
SQL> show error
No errors.

No comments:

Post a Comment

Please feel free to leave a comment