A collection of scripts, errors & resolutions, and code snippets ranging from daily DBA tasks to Linux Administration, to web design using the new HTML5 and CSS3.
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:
No comments:
Post a Comment
Please feel free to leave a comment