How to fix the Oracle error PCC-00121: Arrays of VARCHAR pointers are not supported?

In this post, you’ll learn more about the Oracle ErrorPCC-00121: Arrays of VARCHAR pointers are not supported with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00121: Arrays of VARCHAR pointers are not supported

Reason for the Error PCC-00121: Arrays of VARCHAR pointers are not supported

Cause: An array of pointers was declared, which is not allowed. However, pointers to scalar types are allowed. With Pro*C, declare pointers to char[n] and varchar[n] variables as pointers to CHAR or VARCHAR (with no length specification).

How to fix the Error PCC-00121: Arrays of VARCHAR pointers are not supported ?

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

Action: Correct or remove the declaration.