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-24386: statement/server handle is in use when being freed

1 Answers  


DGM-16906: Unable to accept commands: no memory

1 Answers  


DRG-12005: Please give name of file to save in:

1 Answers  


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

1 Answers  


NZE-28760: list creation failure

1 Answers  






ORA-00216: controlfile could not be resized for migration from 8.0.2

1 Answers  


ORA-13050: unable to construct spatial object

1 Answers  


ORA-39311: illegal clone_recovery() call: it only applys to failed clones

1 Answers  


SQL-02154: Invalid or unset data type for host variable in ANSI Dynamic

1 Answers  


LFI-01001: Unable to write string bytes to file.

1 Answers  


PLS-01424: Non-ANSI order of clauses

1 Answers  


ORA-24375: Cannot use V6 syntax when talking to a V8 server

1 Answers  


Categories