I'm trying to set up a "Watch" on a variable in my pl/sql program and have Toad break when the variable is set to a certain value. I am trying to stop the program when it reaches this condition so I can step through the program and debug a problem.
Use the Conditional Breakpoint not a Watch.
Currently breakpoints can only be set on executable lines.
1. Select View | Options | Procedure Editor | Debugging | Check "Show Executable line indicators in gutter".
2. Re-load the procedure in the Procedure Editor window.
3. You should see blue dots on the left of each line that is an executable line. You may set break points on these blue dots.
4. To set a breakpoint, moves the cursor to the line and hit F5 or select Debug | Set break point. A break point will be set.
5. Once the break point is set, open the break points tab and locate the breakpoint. Double click on the break point to bring up the properties. In the condition line you can add a condition. For example x.style_id ='TOM'. This should stop at the break point you set.
NOTE: If a breakpoint is set at R_Temp:='Hello'
R_TEMP := 'Hello';
R_TEMP := 'HANS';
and your condition is R_TEMP ='Hello' it will not enable the break point. You will need to set the break point after the value for the variable has been set at R_TEMP:='HANS'; .