To view variable values

1. Connect to the database as a user with DBA authority.

2. In the left pane, double-click Procedures & Functions.

3. Select a procedure.

4. Choose Mode » Debug.

5. In the Which User Would You Like To Debug field, type * to debug all users, or type the name of the database user you want to debug.

6. In the right pane, click the line where you want to insert the breakpoint.

   A cursor appears in the line where you clicked

7. Press F9.

   A red circle appears to the left of the line of code.

8. In the Debugger Details pane, click the Local tab.

9. In the left pane, right-click the procedure and choose Execute From Interactive SQL. The variables, along with their values, appear on the Local tab.