PLS-00405: subquery not allowed in this context



PLS-00405: subquery not allowed in this context..

Answer / guest

Cause: A subquery was used in an inappropriate context, such
as: if (SELECT deptno FROM emp WHERE ... ) = 20 then ...
Subqueries are allowed only in SQL statements.

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 ...

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01140: cannot end online backup - all files are offline or readonly

1 Answers  


PCC-02413: Number of attributes does not match number of host variables

1 Answers  


ORA-01580: error creating control backup file string

1 Answers  


LPX-00267: could not resolve relative URL ~s

1 Answers  


O2F-00323: Internal error in OTT facility O2F

1 Answers  






RMAN-04004: error from recovery catalog database: string

1 Answers  


PROT-00001: Failed to initialize ocrconfig

2 Answers  


ORA-01089: immediate shutdown in progress - no operations are permitted

1 Answers  


TNS-00028: INTCTL: Could not resolve Connection Manager's name/address

1 Answers  


NZE-28875: SSL: use server-gated cryptographic suites

1 Answers  


ORA-36961: Oracle OLAP is not available.

1 Answers  


ORA-15029: disk 'string' is already mounted by this instance

1 Answers  


Categories