How to fix the Oracle error PCC-00089: Invalid Oracle TYPE specification?

In this post, you’ll learn more about the Oracle ErrorPCC-00089: Invalid Oracle TYPE specification with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00089: Invalid Oracle TYPE specification

Reason for the Error PCC-00089: Invalid Oracle TYPE specification

Cause: The Oracle external datatype name in an EXE SQL TYPE or EXEC SQL VAR statement is missing or misspelled.

How to fix the Error PCC-00089: Invalid Oracle TYPE specification ?

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

Action: Check the spelling of the external datatype name. If necessary, supply the missing datatype name.