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

ORA-12633: No shared authentication services

1 Answers  


SQL*Loader-00603: Maximum length number of column string is too big for bind array

1 Answers  


NZE-28798: Number of sub-keys application passes to bind does not match that in the key.

1 Answers  


ORA-24763: transaction operation cannot be completed now

1 Answers  


NNL-00814: Total query processing time: string

1 Answers  






KUP-04026: field too long for datatype

1 Answers  


ORA-13483: insufficient memory for the specified GeoRaster data

1 Answers  


PLS-00531: Unsupported type in a VARRAY or TABLE type: 'string'.

1 Answers  


ORA-00470: LGWR process terminated with error

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  


NNO-00154: warning: hint number has invalid server name "string", hint ignored

1 Answers  


NNC-00413: general failure

1 Answers  


Categories