PLS-00217: NUMBER scale constraint must be in range (-84 .. 127)



PLS-00217: NUMBER scale constraint must be in range (-84 .. 127)..

Answer / guest

Cause: A NUMBER variable was declared with a scale that is
outside the legal range. Declarations such as N
NUMBER(10,345) or N NUMBER(10,-100) are not supported.

Action: Change the illegal NUMBER scale constraint, making
sure that it lies in the range -84 .. 127.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00632: warning: forwarder number has missing address, forwarder ignored

1 Answers  


ORA-09293: sksasmo: unable to send message to console

1 Answers  


PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements

1 Answers  


ORA-32034: unsupported use of WITH clause

1 Answers  


ORA-02249: missing or invalid value for MAXLOGMEMBERS

1 Answers  






NNL-00221: Statistic counter logging interval is now string

1 Answers  


PCC-02414: This attribute does not exist in the specified Object

1 Answers  


DRG-52204: error while registering index

1 Answers  


SQL-02112: SELECT..INTO returns too many rows

1 Answers  


ORA-23368: name string cannot be null or the empty string

1 Answers  


RMAN-08092: channel string: specifying datafilecopy of datafile string for proxy backup

1 Answers  


ORA-22317: typecode number is not legal as a number type

1 Answers  


Categories