SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

440025Apr 26 2006 — edited Apr 26 2006

While compiling one package i am getting the error>
PLS-00216: NUMBER precision constraint must be in range (1 .. 38)
The declaration is:
lServerImportRetVal number(40);

Database is Oracle10gdb.

Do i resize the variable to 38... is that advisable.?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2006

Added on Apr 26 2006

6 comments

5,015 views