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

ORA-29866: cannot create domain index on a column of index-organized table

1 Answers  


ORA-03231: the INITIAL extent may not be deallocated

1 Answers  


ORA-30205: invalid Character set

1 Answers  


ORA-02077: selects of long columns must be from co-located tables

1 Answers  


ORA-30132: invalid key index supplied

1 Answers  






ORA-08191: Flashback Table operation is not supported on remote tables

1 Answers  


ORA-28611: bitmap index is corrupted - see trace file for diagnostics

1 Answers  


ORA-29385: cannot create plan directive from string to string

1 Answers  


ORA-00392: log string of thread string is being cleared, operation not allowed

1 Answers  


ORA-38602: FI invalid input cursor

1 Answers  


ORA-31628: error getting worker process exception

1 Answers  


LSX-00287: duplicate key "~S"

1 Answers  


Categories