How to fix the Oracle error PCC-02397: VARCHAR declarations not permitted in #include file?

In this post, you’ll learn more about the Oracle ErrorPCC-02397: VARCHAR declarations not permitted in #include file with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02397: VARCHAR declarations not permitted in #include file

Reason for the Error PCC-02397: VARCHAR declarations not permitted in #include file

Cause: A VARCHAR declaration was found in a file included using a #include form.

How to fix the Error PCC-02397: VARCHAR declarations not permitted in #include file ?

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

Action: Use the EXEC SQL INCLUDE form to include files with VARCHAR declarations instead.