How to fix the Oracle error PCC-00053: FOR variable string is invalid type at line number in file string?

In this post, you’ll learn more about the Oracle ErrorPCC-00053: FOR variable string is invalid type 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-00053: FOR variable string is invalid type at line number in file string

Reason for the Error PCC-00053: FOR variable string is invalid type at line number in file string

Cause: The count variable in a FOR clause has the wrong datatype. The datatype must be NUMBER or LONG (or be compatible with NUMBER or LONG).

How to fix the Error PCC-00053: FOR variable string is invalid type at line number in file string ?

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

Action: Check the declaration and check that the count variable has a datatype of NUMBER or LONG (or a compatible Oracle or host-language datatype).