How to fix the Oracle error PCC-02310: formal parameter VARCHARs should be declared as pointers?

In this post, you’ll learn more about the Oracle ErrorPCC-02310: formal parameter VARCHARs should be declared as pointers with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-02310: formal parameter VARCHARs should be declared as pointers

Reason for the Error PCC-02310: formal parameter VARCHARs should be declared as pointers

Cause: Many C compilers allow structures to be passed to and returned from functions. Although a VARCHAR is implemented as a C struct, VARCHARs must be passed to a function as pointers.

How to fix the Error PCC-02310: formal parameter VARCHARs should be declared as pointers ?

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

Action: Take the address of a VARCHAR when it is passed to a function. See the example in the section “Referencing VARCHAR Variables” in the Programmer’s Guide to the Oracle Precompilers.