ORA-06502 PL/SQL numeric or value error

Asked By David P Owens 0 points N/A Posted on - 12/30/2013

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

• Status: Open
• Question Views: 1007
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By points N/A #179132

ORA-06502 PL/SQL numeric or value error

Hello,

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.

 

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 01/03/2014
• Question Category: Oracle Database