ORA-06502 PL/SQL numeric or value error

Asked By 0 points N/A Posted on -

Hi experts,

I am little confused with this simple error message. From the error understood that number in line 4is too large than the desired one. It means data is assigned to null value or integer larger, don’t understand exactly. So the oracle Number (p,s) is wrong? If I change will it work? Help me experts.

ORA-06502: PL/SQL: numeric or value error: number precision too large ORA-06512: at line 4

Answered By 110 points N/A #179132

ORA-06502 PL/SQL numeric or value error



This error occurred because of a data type trouble. For example, if you try to assign NULL value to a NOT NULL variable, this problem will occur.

To solve this issue, change the data and how it is used, or the declaration method so that its value doesn’t conflict with or violate constraints.

Check the error line 4. Then find out and change the troublesome part.


Login/Register to Answer

Related Questions