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|
ORA-29278: SMTP transient error: string
ORA-02463: Duplicate HASH IS option specified
ORA-39045: invalid metadata remap name string
ORA-01272: REUSE only allowed when a file name is provided.
IMG-00702: unable to initialize image processing environment
EXP-00037: Export views not compatible with database version
ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory
ORA-24167: incompatible rule engine objects, cannot downgrade
ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
QSM-01526: query rewrite is disabled for equivalence, string
NCR-03016: NCRO: Message has bad address
ORA-02458: HASHKEYS must be specified for a HASH CLUSTER