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-19570: file number string is outside valid range of 1 through string

1 Answers  


ORA-27084: unable to get/set file status flags

1 Answers  


ORA-13353: ELEM_INFO_ARRAY not grouped in threes

1 Answers  


ORA-23412: master table's primary key columns have changed

1 Answers  


RMAN-06480: WARNING: archivelog 'string' cannot be found on disk

1 Answers  






ORA-06129: NETTCP: unable to transfer socket ownership to ORASRV

1 Answers  


LPX-00230: invalid character ~1u (~2x) found in a Name or Nmtoken

1 Answers  


ORA-09808: Could not obtain user clearance.

1 Answers  


NNL-00239: Resetting of statistic counters is now disabled

1 Answers  


ORA-19716: error processing format string to generate name for backup

1 Answers  


ORA-29843: indextype should support atleast one operator

1 Answers  


PCC-00009: Invalid host variable at column number in line number of file string

1 Answers  


Categories