I have in a function a thing like this:
FETCH c1 INTO rec;
EXIT WHEN c1%NOTFOUND;
IF (rec.fieldname IN (SELECT fieldname
FROM mytable WHERE fieldname2 = myfunction())) THEN
I get an PLS-00405 error notify and due for documentation it says I can't implement a subquery inside a context. But since I am inside a cursor loop, how I could re-implement that loop with less code for performance cause that SELECT could return more than a row?...
Thanks to all who could give me a tip!