PCC-00092: Length and/or scale incompatible with specified
Oracle datatype



PCC-00092: Length and/or scale incompatible with specified Oracle datatype..

Answer / guest

Cause: An invalid length or scale for an Oracle external
datatype in an EXEC SQL TYPE or EXEC SQL VAR statement was
specified.

Action: Check that a length large enough to accommodate the
external datatype is specified. If a scale is specified,
check that it lies in the range -84..99.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00511: Unable to initialize read functions

1 Answers  


TNS-12622: TNS:event notifications are not homogeneous

1 Answers  


IMG-00522: invalid format for parameter value

1 Answers  


ORA-27469: %s is not a valid string attribute

1 Answers  


ORA-06952: Remote end of the communication issued a forward-reset packet.

1 Answers  


ORA-06794: TLI Driver: shadow process could not retrieve protocol info

1 Answers  


ORA-01681: max # extents (string) reached in LOB segment in tablespace string

1 Answers  


PCB-00207: Invalid use of PIC N or PIC G table variable when NLS_LOCAL=YES

1 Answers  


ORA-19590: conversation already active

1 Answers  


ORA-26682: invalid value for publication_on

1 Answers  


ORA-31093: null or invalid value specified for parameter : string

1 Answers  


NNL-00990: DEFAULT-FORWARDERS-ONLY mode: string

1 Answers  


Categories