Debugging problem

[iwans]

Hello,

When debugging a package, I've got a strange behavior. The comparison operation seems don't work properly.

See below code:

--
IF p_flag <> 'PROCESS' THEN
    batchproc.comfile := UTL_FILE.FOPEN('HOMECOM','result','w');
END IF;
--

During debugging, I can see that p_flag has a value of 'PROCESS'.
But neveretheles, it goes to the statement inside the condition. How could it happen?

Pls help me to resolve this issue. Do I need to configure anything?

 

[colinj]

We've seen this type of problem as well. We put it down to memory as it seemed to be happening with very large packages.

Although it appeared to go through the code when running through a test window, if you looked at the actual execution it did not actually perform it.

 

[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.