How to fix the Oracle error PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.?

In this post, you’ll learn more about the Oracle ErrorPCC-00056: FOR clause not allowed on SELECT statement at line number in file string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.

Reason for the Error PCC-00056: FOR clause not allowed on SELECT statement at line number in file string.

Cause: A FOR clause was used with a SELECT statement. This is not allowed as data returned from the last loop in the execution of the SELECT overwrites data returned in a previous loop.

How to fix the Error PCC-00056: FOR clause not allowed on SELECT statement at line number in file string. ?

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

Action: Remove the FOR clause from the SELECT statement and use a host- language construct to iteratively execute the SELECT statement.