Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-29862: cannot specify FORCE option for dropping non-domain index

1 Answers  


RMAN-08092: channel string: specifying datafilecopy of datafile string for proxy backup

1 Answers  


NNL-01067: Trace level: number

1 Answers  


LFI-00125: Random access only allowed on fixed length record files.

1 Answers  


PLS-00115: this PRAGMA must follow the declaration of 'string'

1 Answers  






PCC-02357: Function calls may not be used as host variable expressions

1 Answers  


ORA-22903: MULTISET expression not allowed

1 Answers  


ORA-12513: TNS:service handler found but it has registered for a different protocol

1 Answers  


RMAN-06403: could not obtain a fully authorized session

1 Answers  


NID-00442: Database has been shutdown, open database with RESETLOGS option.

1 Answers  


PCC-02375: SQL statement found outside the body of a function

1 Answers  


ORA-39065: unexpected master process exception in string

1 Answers  






Categories