How to fix the Oracle error PCC-00087: EXEC SQL TYPE statement not allowed for this host language?

In this post, you’ll learn more about the Oracle ErrorPCC-00087: EXEC SQL TYPE statement not allowed for this host language with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00087: EXEC SQL TYPE statement not allowed for this host language

Reason for the Error PCC-00087: EXEC SQL TYPE statement not allowed for this host language

Cause: An EXEC SQL TYPE statement was used with a host language that does not support user-defined datatype equivalencing. This feature is available only in Pro*C and Pro*Pascal.

How to fix the Error PCC-00087: EXEC SQL TYPE statement not allowed for this host language ?

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

Action: Remove the offending EXEC SQL TYPE statement.