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-19588: %s recid string stamp string is no longer valid

1 Answers  


SQL*Loader-00904: You cannot used the direct path when linked with v5 of the database

1 Answers  


CLSS-03202: out of sync with master: [string] [string] [string] [string]

1 Answers  


DRG-11501: identifier string found in place of column name on line string

1 Answers  


ORA-15123: ASM file name 'string' contains an invalid incarnation number

1 Answers  






ORA-04090: 'string' specifies same table, event and trigger time as 'string'

1 Answers  


ORA-16576: failed to update Data Guard configuration file

1 Answers  


ORA-12042: cannot alter job_queue_processes in single process mode

1 Answers  


ORA-16644: apply instance not available

1 Answers  


ORA-24313: user already authenticated

1 Answers  


ORA-01863: the year is not supported for the current calendar

1 Answers  


KUP-04012: file length is too large for output field

1 Answers  


Categories