Stack Overflow
Stack Overflow

Questions tagged [ora-01426]

ORA-01426: Numeric Overflow

ORA-01426: Numeric Overflow

Cause:

You tried to evaluate an expression that resulted in a numeric overflow (or underflow).

Action:

The options to resolve this Oracle error are:

  1. Re-write your expression using fewer operands.
  2. Make sure that your expression does not evaluate to infinity.
8 questions
4
votes
2 answers

Oracle11g numeric overflow in for loop

I have a for loop in pl/sql function something like: FOR i IN min..max LOOP variables i, min, max are declared as NUMERIC in my case min and max are ofen very large, but range itself is small, ie: min = 3232236033 max = 3232236286 as You see range…
canni
  • 5,737
  • 9
  • 46
  • 68
2
votes
2 answers

ORA-01426: numeric overflow exception when executing stored procedure

I ported a Delphi 6 application to Delphi 2007 and it uses BDE to connect to an Oracle 9i database. I am getting an ORA-01426: numeric overflow exception When I execute a stored procedure. This happens randomly and if I re-run the stored procedure…
user9977
  • 454
  • 5
  • 5
2
votes
1 answer

Numeric Overflow exception with collection.EXISTS(n) method

I'm getting ORA-01426: numeric overflow when running the following piece of code on Oracle 11g database: DECLARE TYPE my_type IS RECORD ( a NUMBER, b VARCHAR2(10) ); TYPE my_table IS TABLE OF my_type INDEX BY…
Slav Pilus
  • 197
  • 1
  • 10
2
votes
3 answers

Can dbms_utility.get_time rollover?

I'm having problems with a mammoth legacy PL/SQL procedure which has the following logic: l_elapsed := dbms_utility.get_time - l_timestamp; where l_elapsed and l_timestamp are of type PLS_INTEGER and l_timestamp holds the result of a previous call…
skaffman
  • 398,947
  • 96
  • 818
  • 769
1
vote
3 answers

Getting an ORA-01426: Numeric Overflow in .NET 4.0, C#, using the Oracle DataAccess .dll

I am trying to write a very simple webpage using Visual Studio 2010, .Net 4, C#. I am using the Oracle DataAccess .DLL and have made a connection to the database just fine. When I run this code, I get the exception 'ORA-01426: Numeric Overflow." …
Dbloom
  • 1,302
  • 3
  • 18
  • 45
1
vote
1 answer

Inserting +1.7976931348623155E308 into column ORA-01426 numeric overflow

I am porting an application that used a large Java double value (MAX-1d = +1.7976931348623155E308) as a semaphore to indicate a condition. I can not figure out how to define the column to accept this value without yielding the error: ORA-01426:…
Nathaniel Mills
  • 321
  • 4
  • 7
0
votes
1 answer

NHibernate/Oracle : how to insert large number in BINARY_DOUBLE column?

I have a C# System.Double property which may contains value like 1e250 : public virtual double DoubleValue {get; set;} The property is mapped to a BINARY_DOUBLE column : Max value for…
Vivien Ruiz
  • 618
  • 3
  • 11
0
votes
0 answers

ORA-01426: numeric overflow error while doing commit in procedure

I am struggling with subject mentioned error during execution of my PL/SQL code, during debugging of my code i have observed that my database is not allowing me to use 'COMMIT' in procedure while using DBMS_JOB.SUBMIT. My procedure is a bit complex,…
SuryaV
  • 41
  • 1
  • 5