PCC-00090: Precision/scale specification must be given for
DECIMAL datatype



PCC-00090: Precision/scale specification must be given for DECIMAL datatype..

Answer / guest

Cause: A precision and/or scale specification for the Oracle
external datatype DECIMAL in an EXEC SQL TYPE or EXEC SQL
VAR statement was omitted.

Action: Add the precision and/or scale specification to the
EXEC SQL TYPE or EXEC SQL VAR statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-01052: Server has been running for: string

1 Answers  


ORA-13837: invalid HASH_VALUE

1 Answers  


ORA-19701: device name exceeds maximum length of string

1 Answers  


RMAN-08585: copying standby controlfile

1 Answers  


ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0

1 Answers  






ORA-06600: LU6.2 Driver: SNA software is not loaded

1 Answers  


PLS-00585: declared support library for opaque type is not a library

1 Answers  


LPX-00660: Not a well-formed document or external entity.

1 Answers  


PLS-00351: Not logged onto database 'string'

1 Answers  


ORA-12014: table 'string' does not contain a primary key constraint

1 Answers  


ORA-02197: file list already specified

1 Answers  


ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.

1 Answers  


Categories