How to fix the Oracle error PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL?

In this post, you’ll learn more about the Oracle ErrorPCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL

Reason for the Error PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL

Cause: A length for the ROWID, DATE, or MLSLABEL external datatype was specified in an EXEC SQL TYPE or EXEC SQL VAR statement. This is unnecessary because those are fixed length types.

How to fix the Error PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL ?

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

Action: Remove the length specification from the EXEC SQL TYPE or EXEC SQL VAR statement.