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

ORA-28112: failed to execute policy function

1 Answers  


ORA-02486: Error in writing trace file string

1 Answers  


RMAN-06114: changed controlfile copy available

1 Answers  


ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.

1 Answers  


ORA-02089: COMMIT is not allowed in a subordinate session

1 Answers   Oracle,






ORA-00740: datafile size of (string) blocks exceeds maximum file size

1 Answers  


ORA-06118: NETTCP: unable to complete handshake with ORASRV

1 Answers  


ORA-01955: DEFAULT ROLE 'string' not granted to user

1 Answers  


IMG-00517: height or width not present in parameter string

1 Answers  


QSM-01110: a lossy join in MV, string, between tables, string, not found in query

1 Answers  


ORA-12052: cannot fast refresh materialized view string.string

1 Answers  


ORA-00358: Too many file members specified, the maximum is string

1 Answers  


Categories