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


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

NZE-29020: The handshake record length is too long.

1 Answers  


PLS-00555: default expressions are not allowed for SQL operators

1 Answers  


DRG-50101: CORE LEM error: string

1 Answers  


SQL*Loader-00432: converted data too large

1 Answers  


QSM-02153: inline view or subquery in FROM list not supported for this type MV

1 Answers  






ORA-15068: maximum number of diskgroups string already mounted

1 Answers  


ORA-24809: amount specified will not fit in the lob buffers

1 Answers  


ORA-30154: The memory address given as buffer for OCIFileRead/Write is invalid

1 Answers  


RMAN-06570: datafile number switched to datafile copy "string"

1 Answers  


ORA-27102: out of memory

1 Answers  


NNO-00265: warning: cannot load data from checkpoint file

1 Answers  


ORA-01221: data file string is not the same file to a background process

1 Answers  






Categories