|
|
 Ora-1438 Error with Array DML
|
Joined: Dec 2001
Posts: 5 Phoenix, AZ
Member
|
OP
Member
Joined: Dec 2001
Posts: 5 Phoenix, AZ |
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
|
|
|
 Re: Ora-1438 Error with Array DML
|
Joined: Aug 1999
Posts: 22,221
Member
|
|
Member
Joined: Aug 1999
Posts: 22,221 |
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
Marco Kalter
Allround Automations
|
|
|
 Re: Ora-1438 Error with Array DML
|
Joined: Dec 2001
Posts: 5 Phoenix, AZ
Member
|
|
OP
Member
Joined: Dec 2001
Posts: 5 Phoenix, AZ |
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
|
|
|
 Re: Ora-1438 Error with Array DML
|
Joined: Aug 1999
Posts: 22,221
Member
|
|
Member
Joined: Aug 1999
Posts: 22,221 |
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
Marco Kalter
Allround Automations
|
|
|
Re: Ora-1438 Error with Array DML
|
Joined: Dec 2001
Posts: 5 Phoenix, AZ
Member
|
|
OP
Member
Joined: Dec 2001
Posts: 5 Phoenix, AZ |
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
|
|
|
Re: Ora-1438 Error with Array DML
|
Joined: Aug 1999
Posts: 22,221
Member
|
|
Member
Joined: Aug 1999
Posts: 22,221 |
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
Marco Kalter
Allround Automations
|
|
|
Re: Ora-1438 Error with Array DML
|
Joined: Dec 2001
Posts: 5 Phoenix, AZ
Member
|
|
OP
Member
Joined: Dec 2001
Posts: 5 Phoenix, AZ |
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
|
|
|
Re: Ora-1438 Error with Array DML
|
Joined: Dec 2001
Posts: 5 Phoenix, AZ
Member
|
|
OP
Member
Joined: Dec 2001
Posts: 5 Phoenix, AZ |
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
|
|
|
|
|
|
|
