How to fix the Oracle error PCC-00088: User defined type identifier expected?

In this post, you’ll learn more about the Oracle ErrorPCC-00088: User defined type identifier expected with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00088: User defined type identifier expected

Reason for the Error PCC-00088: User defined type identifier expected

Cause: The user-defined datatype name in an EXEC SQL TYPE statement is missing or misspelled, is a reserved word, is not a legal identifier in the host-language or conflicts with a base datatype in that language.

How to fix the Error PCC-00088: User defined type identifier expected ?

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

Action: Check the spelling of the user-defined datatype name. If necessary, declare a valid user-defined datatype. User-defined datatype equivalencing is available only in Pro*C and Pro*Pascal.