Module 15: Debugging Triggers

Debugging Triggers

 

01. What are the debugging process components?

The Debugging Process

•  Compiling and correcting errors in the PL/SQL Editor

•  Displaying debug messages at run time

•  Invoking the PL/SQL Debugger

02. Write down the debugging tips to solve a problem.

Debugging Tips:

•  Connect to the database for SQL compilation.

•  The line that fails is not always responsible.

•  Watch for missing semicolons and quotation marks.

•  Define triggers at the correct level.