CODEWITHSUNDEEP
oracle-databasedelphidelphi-2007bdeora-01426
user9977
user9977

Reputation: 454

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 through the application with the same parameters the exception does not occur.

The old Delphi 6 application works just fine.

Ideas anybody?

Upvotes: 2

Views: 7673

Answers (2)

Argalatyr
Argalatyr

Reputation: 4659

Does the D6 version of the app use the same version of BDE, Oracle, and the database? If so, then it's probably something about the data being passed (either content or mechanism).

Not knowing what those data are, nor how they are passed, makes it pretty hard to diagnose.

Upvotes: 0

Argalatyr
Argalatyr

Reputation: 4659

Showing a code example could make this easier, but here are a couple of hunches:

  1. Are the data coming from another source (like Excel) that does not have explicit data types? Mixed or ambiguous data may be causing BDE to assign the wrong data type to a field that then is incompatible with the database field.

  2. Could be a numeric formatting issue (some U.S.-centric components do not handle localization properly). Is your localization other than English(U.S.)? Is so, does changing it to English(U.S.) fix the problem?

If these completely miss, more details might help.

Upvotes: 2

Related Questions