In this post, you’ll learn more about the Oracle ErrorPCC-00091: TYPE statement requires format specification for this Oracle datatype with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PCC-00091: TYPE statement requires format specification for this Oracle datatype
Reason for the Error PCC-00091: TYPE statement requires format specification for this Oracle datatype
Cause: A length, precision, and/or scale specification for an Oracle external datatype in an EXEC SQL TYPE or EXEC SQL VAR statement was omitted.
How to fix the Error PCC-00091: TYPE statement requires format specification for this Oracle datatype ?
You can fix this error in Oracle by following the below steps
Action: Add the length, precision, and/or scale specification for the external datatype to the EXEC SQL TYPE or EXEC SQL VAR statement.