PLS-00216: NUMBER precision constraint must be in range (1
.. 38)



PLS-00216: NUMBER precision constraint must be in range (1 .. 38)..

Answer / guest

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

Action: Change the illegal NUMBER precision constraint,
making sure that it lies in the range 1 .. 38.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02105: Unable to open list file

1 Answers  


TNS-00080: * force_log - ask process_name to dump its state

1 Answers  


DRG-12801: invalid type: string

1 Answers  


ORA-01157: cannot identify/lock data file string - see DBWR trace file

1 Answers  


SQL*Loader-00914: Error locking table string in exclusive mode.

1 Answers  






ORA-16032: parameter string destination string cannot be translated

1 Answers  


ORA-32161: Cannot perform piecewise fetch

1 Answers  


RMAN-06092: error while looking up backup piece

1 Answers  


PCC-02379: Cannot equivalence National Language character variables

1 Answers  


TNS-01154: SID detected in old format that is no longer supported

1 Answers  


QSM-02039: top level mv query uses grouping sets

1 Answers  


ORA-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 Answers  


Categories