debugging problem

Hi
I am trying out the trial version and would
buy it if I am satisfied with the product.

I was tryign to step through some code,
when I noticed that it was stepping through
both the IF and the ELSIF part
IF( ... ) THEN
statement 1;
ELSIF ( ...) THEN
statment 2;
END IF;

It is stepping through both the above statements.
I put dbms_output and confirmed that only
one of the statements is getting executed
(just being paranoid.)

So, is the source code out of sync with the
code I see. I have the program window
opened for the pl/sql file and compiled it
from plsql dev.

I have selected the option to have debug
information when compiling.. Please let me know
if this is a bug (a serious one, IMHO, if so)
or if I am missing something here...

Thanx!

 

[Marco Kalter]

This is probably a known Oracle Server bug (bug# 2276832). For if-then-else constructs it sometimes reports incorrect execution line numbers. The actual execution is okay though, but it is confusing.

 

Wow! So that means this would be reproducible in other IDEs as well? I will try it out in other IDEs and see if they show the same issue.
This definitely leads to loss of confidence in product as stepping through code is one of the most important features of the IDE.

 

[ScottMattes]

I have seen the same thing in Oracle Forms and Reports. It is ugly, but not PLSD's fault.

 

[orca777]

Originally posted by M:
Wow! So that means this would be reproducible in other IDEs as well? I will try it out in other IDEs and see if they show the same issue.
This definitely leads to loss of confidence in product as stepping through code is one of the most important features of the IDE.

Hi, you must know that debugging is not an IDE feature it's a servserside feature, alle IDE's have to use the dbms_debug interface package of the Oracle Server for debugging - ence the code is executed on the Oracle Server and not in the IDE;
Regards
Carl