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