PCC-00056: FOR clause not allowed on SELECT statement at
line number in file string.



PCC-00056: FOR clause not allowed on SELECT statement at line number in file string...

Answer / guest

Cause: A FOR clause was used with a SELECT statement. This
is not allowed as data returned from the last loop in the
execution of the SELECT overwrites data returned in a
previous loop.

Action: Remove the FOR clause from the SELECT statement and
use a host- language construct to iteratively execute the
SELECT statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12419: null binary label value

1 Answers  


ORA-00397: instance recovery process terminated with error

1 Answers  


ORA-02056: 2PC: string: bad two-phase command number string from string

1 Answers  


DRG-10832: can not delete from feedback table string

1 Answers  


PLS-00218: a variable declared NOT NULL must have an initialization assignment

1 Answers  






PLS-00112: end-of-line in quoted identifier

1 Answers  


ORA-09281: sllfop: error opening file

1 Answers  


ORA-07680: sou2os: another call to ORACLE currently executing

1 Answers  


NNO-00112: line string: ignored duplicate data of type "string"

1 Answers  


ORA-14603: [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables

1 Answers  


ORA-10657: Lob column to be shrunk does not exist

1 Answers  


ORA-00001: unique constraint (string.string) violated

1 Answers  


Categories