I am trying to compile my oracle stored proc, but the code keeps erroring on the following line:
elsif v_CODE NOT IN (Select CODE from CODE_TBL) then
I get an "PLS-00405: subquery not allowed in this context" error. If I run the embedded select statement in SQL+, it works fine, so I know the problem is not that the select statement is wrong
Is what I am trying to do not allowed? If it's not allowed, is there another way to do it?