Debug issues

[Dave876]

Hi,

TT.PROC1 makes a call to XX.PROC2.
XX.PROC2 is owned by another schema and executes :
select count(1) from tablea where col1 = parsed_val;

tablea is owned by the same schema as XX.PROC2.

The record definately exists in tablea - running the query manually returns the correct result.

If I execute the full procedure without trying to debug it (I am using PL/SQL Developer 7.1) it will run fine. When I try to step through the count does not find any matches - and screws everything up.

Is this a permissions thing? Or is the 'focus' changed somehow when debugging?

Any help would be great!!

Cheers,
David.

 

[Marco Kalter]

Do you mean that the results are different when you run the program in debug mode (F9) compared to normal mode (F8)?