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-25442: too many column values for table alias: string

1 Answers  


ORA-29557: Java system class string cannot be modified

1 Answers  


ORA-14006: invalid partition name

1 Answers  


ORA-27210: syntax error in device PARMS

1 Answers  


ORA-09240: smpalo: error allocating PGA memory

1 Answers  






DRG-50929: parser internal on line string on column string

1 Answers  


PCC-00103: AT clause is an Oracle extension

1 Answers  


PLS-00538: subprogram or cursor 'string' is declared in an object type specification and must be defined in the object type body

1 Answers  


ORA-16609: one or more resources have failed

1 Answers  


ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION

1 Answers  


TNS-00558: Entrust login failed

1 Answers  


SQL*Loader-00605: Non-data dependent ORACLE error occurred -- load discontinued.

2 Answers  


Categories