How to fix the Oracle error PCB-00553: FOR clause not allowed on this statement?

In this post, you’ll learn more about the Oracle ErrorPCB-00553: FOR clause not allowed on this statement with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCB-00553: FOR clause not allowed on this statement

Reason for the Error PCB-00553: FOR clause not allowed on this statement

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.

How to fix the Error PCB-00553: FOR clause not allowed on this statement ?

You can fix this error in Oracle by following the below steps

Action: Remove the FOR clause from the statement. Use a host language construct to iteratively execute the statement.