PCB-00553: FOR clause not allowed on this statement



PCB-00553: FOR clause not allowed on this statement..

Answer / guest

Cause: A FOR clause was used with a SELECT, LOB, or
DEALLOCATE DESCRIPTOR statement. A FOR clause cannot be used
with these statements. In the case of a SELECT statement,
data returned from the last loop in the execution of the
SELECT would overwrite data returned in a previous loop.

Action: Remove the FOR clause from the statement. Use a host
language construct to iteratively execute the 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-22991: insufficient space allocated for argument string

1 Answers  


SQL*Loader-00132: invalid argument for external table option

1 Answers  


ORA-10615: Invalid tablespace type for temporary tablespace

1 Answers  


ORA-28523: ORACLE and heterogeneous agent are incompatible versions

1 Answers  


RMAN-06746: backup cancelled because all files were skipped

1 Answers  


ORA-16116: no work available

1 Answers  


ORA-08270: sksachk: Illegal archival control string

1 Answers  


ORA-30678: too many open connections

1 Answers  


PCB-00226: SQL identifier "string" already defined

1 Answers  


ORA-16527: unable to allocate SGA heap

1 Answers  


QSM-02171: the materialized view has a join operation in the outer UNION block

1 Answers  


ORA-12669: Shared server: outbound protocol does not support proxies

1 Answers  


Categories