Ora-1438 Error with Array DML

[scottbruns]

I'm using DOA v 3.3.1 on Delphi 3.

My program inserts into several tables using array DML. Sometimes I receive an 'ORA-01438: value larger than specified precision allows for this column' error. When this happens I dump out the array and I find that no field would cause this error.

I've seen a similar error reported, but my error happens in the middle of the array, not at array index 0.

Is this a known bug? Unfortunately I cannot reliably reproduce the error.

Any help would be appreciated.

Scott Bruns

 

[Marco Kalter]

It may be that you are running into a bug that was fixed in version 3.4.5:

"Decreasing the array size to 1 for subsequent Array DML statements could cause errors on Net8"

Could this be the case?

------------------
Marco Kalter
Allround Automations

 

[scottbruns]

We did see that problem, but this problem does not occur when the array is resized to 1. In addition, we have already turned optimization off, as was already suggested.

Maybe it has been fixed in a patch or a later release. What do I need to do to get an update to DOA?

Scott

 

[Marco Kalter]

Could you send me know the table definition, array insert statement, and the Delphi code that provides the array values? Maybe I can find a clue.

It may indeed be a good idea to try the latest Direct Oracle Access release first. If your license does not allow you to upgrade to the latest release, you can purchase an annual service contract here .

------------------
Marco Kalter
Allround Automations

 

[scottbruns]

I downloaded and installed DOA 3.4.5 for Delphi3. Even with the new version we are still getting this error.

I'm having my DBA look into the problem from his perspective.

I can't pull the code out of my app to send to you. It is very complex and will not run by itself. I may try to build a new test program to see if I can cause the error to happen. So far I've had no luck reproducing the error.

Scott

 

[Marco Kalter]

Hmm, perhaps you can also try a different SQL*Net or Net8 version? Maybe you are running into some SQL*Net or Net8 specific Oracle bug. What version are you using by the way?

------------------
Marco Kalter
Allround Automations

 

[scottbruns]

It turns out that some of the stations are running Net8 v8.0.5 and some are running v8.0.6. I don't know if anyone running 8.0.6 is having the problem, but I DO know that the problem is happening on machines running 8.0.5.

On Monday all the machines involved will be upgraded to 8.0.6. I'll post what happens next week.

Scott

 

[scottbruns]

Marco,

it's been a few days since we upgraded everyone to the 8.0.6 client. All the array errors have gone away.

For now it looks like it has been fixed. I'll post something again if the problem resurfaces.

Thanks for your help.

Scott Bruns