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-07801: slbtpd: invalid exponent

1 Answers  


UDE-00017: Data Pump job is already executing.

1 Answers  


ORA-36614: (XSLMS02) string attempted to retrieve a nonexistent user message. (Message number number)

1 Answers  


TNS-04009: %-25s | number

1 Answers  


TNS-12655: Password check failed

1 Answers  






O2U-00210: Unable to allocate memory

1 Answers  


ORA-28527: Heterogeneous Services datatype mapping error

1 Answers  


PROC-00101: Operating System error [string]

1 Answers  


ORA-07561: szprv: $IDTOASC failure

1 Answers  


ORA-32823: subscriber exists for queue string and destination string

1 Answers  


LPX-00310: element ~S not found in ~S

1 Answers  


ORA-23446: duplicate template site

1 Answers  


Categories