Unanswered: CALLING a function inside "where" clause
I want to put a condition in the where clause of my block, the condistion is like this:
where get_id is a function inside the package pkg. But in the runtime
it tells that 'Query caused no records to be retrieved'.
I don't know the reason of it, even I did call the function the same previous way in other
part of the form and it worked, but in here it doesn't work.
if anyone knows why and how to make it work, plz tell me.
PROCEDURE TAKE ( FLAG IN VARCHAR2)
PKG.LMN := FLAG;
FUNCTION GET RETURN VARCHAR2
and I make sure of the matching data type. and to make sure that there's a record that matches the value been sent I make LMN equals to an existing ID.
I really this WHERE CLAUSE to work effeciently, cause my whole project depends on it.