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

IMG-00802: empty or null attribute string

1 Answers  


PLS-00303: qualifier 'string' must be declared

1 Answers  


ORA-16623: stale DRC UID sequence number detected

1 Answers  


NNL-00413: Total response time: string

1 Answers  


RMAN-06419: file string cannot be proxy restored from handle string

1 Answers  






ORA-19002: Missing XMLSchema URL

1 Answers  


ORA-19361: ONLINE option not allowed with this type of index

1 Answers  


ORA-23453: requested operation is not supported on top flavor

1 Answers  


ORA-30360: REF not supported with query rewrite

1 Answers  


ORA-30444: rewrite terminated by the sql analyzer

1 Answers  


SQL*Loader-00257: TERMINATED BY EOF option not valid with ENCLOSED BY option

1 Answers  


PLS-00721: 'string' formed a non-REF mutually-dependent cycle with 'string'

1 Answers  


Categories