Oracle Error :: PLS-00216
NUMBER precision constraint must be in range (1 .. 38)
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.
Comments (Add Comment)
19/03/2008 13:53:19 by subrat
Hi,
If the data type is declared as ONLY NUMBER type for exp.
EmpNo NUMBER;
then what's the maximum size we can declare or how to overcome this problem.
Please advice me. Appreciate ur help.
Thanks,
Subrat