Stored Procedure Test Issue

[Mike Jansen]

I am using version 8.0.0.1480 on an Oracle 9.2.0.1.0 database and have been encoutering a fustrating problem when trying to test a stored procedure. I seems that when steping though the procedure using PL/SQL Developer the highlighted cursor does not following the program logic. That is after exectuing a specific IF statement, the debugger junps to an execuable line 10 lines below located in a different If-THEN-ELSE block.

Has anyone seen this behavior. The stored procedures is rather large (1950 lines).

Mike J

 

[Marco Kalter]

This is 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.

 

[Mike Jansen]

Thanks Marco!