How to debug a trigger in SQL Nav ?
One way to step through the trigger code is to embedded the SQL statement which invoke the trigger in an anonymous block. Steps are outline below:
1. Open trigger in Editor and turn on the PL/SQL Debugger
2. Set a breakpoint in trigger code
2. Write an anonymous block containing SQL statement(s) which will invoke the trigger
3. Run the anonymous block (F9) . Once the statement is executed, users can step through the trigger code.
