Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-06569: Collection bound by bind_array contains no elements

1 Answers  


ORA-31102: Already locked in exclusive mode. Cannot add lock.

1 Answers  


ORA-32820: subscriber queue and exception queue must use same message system link

1 Answers  


ORA-13152: invalid HHCODE type

1 Answers  


ORA-30183: invalid field width specifier

1 Answers  






NZE-29114: Cannot import private key.

1 Answers  


ORA-01591: lock held by in-doubt distributed transaction string

1 Answers  


ORA-31223: DBMS_LDAP: cannot open more than string LDAP server connections

1 Answers  


ORA-10663: Object has rowid based materialized views

1 Answers  


TNS-01442: No filtering rules currently in effect.

1 Answers  


ORA-08414: error encountered in string

1 Answers  


ORA-19660: some files in the backup set could not be verified

1 Answers  






Categories