Set breakpoint at perticular iteration of a loop

[P J S]

Hi,

I am using PLSQL developer version 7.1.5.1398.
I am trying to debug procedure wherein a loop is having 2048 iterations. I want to set up a breakpoint for a perticular iteration.
Can it be possible ?
Looking forward for your support.

Thanks and regards,
--P J S

 

[Marco Kalter]

You can set a condition for a breakpoint within the loop. To do so, right-click on the breakpoint, select "Modify breakpoints", and enter the condition in the "Use condition" field for the breakpoint. Prefix the variable name with a colon, for example:

:counter = 1000

Now execution will halt when the line of the breakpoint is passed and the "counter" variable has a value of 1000.

 

[P J S]

Thanks a lot for your reply... Will try this..
--P J S

 

[P J S]

Hi,

Thanks for your help. It worked. I have successfully debugged at perticular iteration of loop.

Thanks and regards,
--P J S