Database Error Messages

PLS-00405

subquery not allowed in this context

Action

The same result can be obtained by using a temporary variable, as in: SELECT deptno INTO temp_var FROM emp WHERE ...; IF temp_var = 20 THEN ...