How to get information about compile error in Oracle/TOAD

How to get information about compile error in Oracle/TOAD

You can either add SHOW ERRORS to the end of the script, which will print the error message(s) to the script output tab, or compile the function using the Execute Statement command in Toad, which will cause the errors to be displayed in a box at the bottom of the editor.

Or you can look in USER_ERRORS table afterwards

How to get information about compile error in Oracle/TOAD

Click on Database -> Procedure Editor in top tool bar.

Paste your code in this new editor window and execute by clicking green play button on top.

All the errors will be displayed in a new window at the bottom.

Leave a Reply

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