Handling PL/SQL Exceptions

This section describe how the PL/SQL Debugger handles exceptions that are not caught.

When an uncaught PL/SQL exception occurs in the execution, a dialog box appears informing you of this and providing the following information:

Exception Name: If the PL/SQL exception is a user-defined exception, the exception name is displayed as EXCEPTION_USER. If the exception is a predefined PL/SQL exception, the exception name is displayed as EXCEPTION_ORA_ORACLE_ERROR_NUMBER.

Line number: The line where the PL/SQL exception occurred.

Program Name: The name of the PL/SQL program where the PL/SQL exception occurs. If the execution breaks at the package method, it displays the package name.

The dialog box allows you to select from the following operations:

Break: The debugger breaks at the location where PL/SQL exception occurs.

Continue: The debugger continues the program execution.

Ignore: This option does not appear in Visual Studio.