Page 1 of 1

Setting Breakpoints

Posted: Fri 25 May 2007 14:30
by jeananns
I am evaluating the latest beta (trial) for possible purchase, I am debugging a stored procedure with an embedded procedure. I can set breakpoints in parts of the code and not in others.

In the embedded procedure, I can set breakpoints on the first two statements, (in order) an assignment and an if, but not on the remaining statements. In the main procedure, I can set breakpoints on the first 6 statements, (in order) an assignment, an sql delete, a commit, 2 selects and an if, but not on the remaining statements.

In writting this, I noticed that the commonality was the if statement, so I opened another stored procedure and low an behold I could set break points until right after the first if statement .

Any ideas?

Posted: Fri 25 May 2007 15:09
by Duke
We need procedure code to make conclusion. This can be our error or Oracle Probe restriction.

Posted: Fri 25 May 2007 16:54
by jeananns
You mean you want my procedures???

The files are not very big 12k and 6 k, but I do not see anyway to attach them. Besides you would need part of my schema just to compile them.

Posted: Tue 29 May 2007 14:42
by Elias
Actually we need a listing of your PL/SQL code for reproducing the problem. We don't need to compile it or run.