| Author |
Message
|
| Lazy |
 Posted: Thu Jan 02, 2014 12:29 pm Post subject: Error with IIB 9.0 Oracle ODBC [ORA-01426: numeric overflow] |
 |
|
Newbie
Joined: 23 Sep 2013
Posts: 7
|
Hello,
We are in the process of upgrading WMB 6.1 to IIB 9.0, and we got IIB 9.0 installed on Windows Server environment.
In one of the flows we have defined an eSQL compute node that connects to Oracle Database, via ODBC Data Source, and execute a stored procedure. Within WMB 6.1, the flow works perfectly, however, when we migrated the same flow to IIB 9.0 we got the following error:
| Code: |
| [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-01426: numeric overflow |
Initially we thought its related to database or pl/sql execption. However, the same flow, with the exact parameters is working perfectly on WMB 6.1. We tried executing the stored procedure directly against Oracle DB, and its working without any issues.
We noticed that this issue is common to all Oracle ODBCs defined in IIB 9.0 and not only to one single instance.
We are using 64bit DFE along with 64bit DataDirect Oracle Wire Protocol.
Any idea what could be the issue?  |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Thu Jan 02, 2014 12:55 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Well Mr Lazy, have you searched on the internet for instances of 'ORA-01426'. The first one I looked at was related to stored procedure calls.
These might be worth some investigation.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Lazy |
| Posted: Mon Jan 06, 2014 6:14 am Post subject: |
|
|
Newbie
Joined: 23 Sep 2013
Posts: 7
|
| smdavies99 wrote: |
Well Mr Lazy, have you searched on the internet for instances of 'ORA-01426'. The first one I looked at was related to stored procedure calls.
These might be worth some investigation. |
It has nothing to do with the Oracle Procedure. IIB 9.0 doesn't support Oracle 9i, that's the main reason behind this error.
We have implemented a workaround to get Oracle 9i working. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Jan 07, 2014 5:49 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
The right thing would have been to upgrade to oracle 11g! Not implement some unsupported work around... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jan 07, 2014 6:04 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Lazy wrote: |
We have implemented a workaround to get Oracle 9i working. |
It would have been nice to have seen 'Oracle 9i' mentioned in your original post.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Avi A |
| Posted: Wed Jan 28, 2015 11:51 pm Post subject: oracle 9 issue with IIB 9 - ora-1426 numeric overflow |
|
|
Newbie
Joined: 28 Jan 2015
Posts: 1
|
hi we also had an issue when trying to connect to oracle 9 from IIB 9.0.0.2
we got some errors like ora-1426 numeric overflow
or sometimes the return from the SP were with bad characters
the solution for us was to deploy the old driver UKase24.so and libUKicu24.so to the drivers library on the IIB and then change the ODBC path to call this one
for now it look like it solved the problem
and the code started working as it used to on wmb 7 |
|
| Back to top |
|
|
|
|
