Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-29278: SMTP transient error: string

1 Answers  


ORA-02463: Duplicate HASH IS option specified

1 Answers  


ORA-39045: invalid metadata remap name string

1 Answers  


ORA-01272: REUSE only allowed when a file name is provided.

1 Answers  


IMG-00702: unable to initialize image processing environment

1 Answers  






EXP-00037: Export views not compatible with database version

1 Answers  


ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory

1 Answers  


ORA-24167: incompatible rule engine objects, cannot downgrade

1 Answers  


ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

1 Answers  


QSM-01526: query rewrite is disabled for equivalence, string

1 Answers  


NCR-03016: NCRO: Message has bad address

1 Answers  


ORA-02458: HASHKEYS must be specified for a HASH CLUSTER

1 Answers  






Categories