Originally posted by JayM
"ASDF" is what i input on the gui. this column is defined as a varchar2, so i don't see why it's having problems doing the following comparison:

Code:
AND OT.ADMINISTRATION = ' || IN_PROGRAM;
IT seems like the problem is not in test but somewhere else. The problem could be in the gui. If this is a part of a package that has an initialization section that references ASDF, that could also be the problem.