In this post, you’ll learn more about the Oracle ErrorPCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types
Reason for the Error PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types
Cause: In an EXEC SQL VAR statement, a VARCHAR or VARRAW external datatype was specified without a length. Unlike other types, the maximum length of the data field must be specified for VARCHAR and VARRAW.
How to fix the Error PCC-00114: Length spec required in EXEC SQL VAR statements for VARxxx types ?
You can fix this error in Oracle by following the below steps
Action: Add a length specification to the EXEC SQL VAR statement.