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

AUD-00703: unable to read audio data

1 Answers  


LPX-00316: invalid value ~S for ~S attribute ~S

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  


O2I-00127: Illegal INITFUNC name

1 Answers  


ORA-13904: The file has been dropped and recreated during the procedure call.

1 Answers  






AMD-00133: measure #string: analytic workspace measure name not specified

1 Answers  


ORA-07487: scg_init_lm: cannot create lock manager instance.

1 Answers  


ORA-30731: scope constraint not allowed on nested table column when the nested table is being created

1 Answers  


RMAN-06049: CHECK LOGICAL option not supported for archive log or current/standby controlfile copies

1 Answers  


ORA-12818: invalid option in PARALLEL clause

1 Answers  


ORA-04930: open sequence number failed or initial state is valid

1 Answers  


DRG-12301: index does not exist in index set

1 Answers  


Categories