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

PLS-00494: coercion into multiple record targets not supported

1 Answers  


NNL-00343: Log file name is now string

1 Answers  


ORA-01519: error while processing file 'string' near line string

1 Answers  


PLS-00169: modifier 'string' conflicts with prior 'string' specification

1 Answers  


PLS-00504: type string_BASE may not be used outside of package STANDARD

1 Answers  


LSX-00153: invalid combination of default and fixed attributes

1 Answers  


NNL-01077: Save Config on Stop string

1 Answers  


DRG-11527: end token not found on line string

1 Answers  


ORA-24160: name string already exists in the name value pair list

1 Answers  


ORA-09826: SCLIN: cannot initialize atomic latch.

1 Answers  


ORA-16760: Resource guard could not start logical apply engine

1 Answers  


ORA-39023: Version string is not supported.

1 Answers  


Categories