|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
|
|
ODBC Oracle Wire Protocol driver Error |
« View previous topic :: View next topic » |
Author |
Message
|
kirankinnu |
Posted: Thu Jul 29, 2010 7:53 am Post subject: ODBC Oracle Wire Protocol driver Error |
|
|
Centurion
Joined: 12 Jun 2004 Posts: 128 Location: Chicago, IL
|
Hi All,
I am trying to retrieve some data from Oracle Tables. I am using ODBC Oracle Wire Protocol driver for establishing connection. The very first call runs fine, but I keep getting the below error for subsequent call.
"[IBM][ODBC Oracle Wire Protocol driver]Data type for parameter 1 has changed since first SQLExecute call.'
If i give a time delay of 1 minute between each call, it runs fine. I have Enable SQLDescribeParams and Procedure Returns Results checked under Driver Setup.
Am I missing any setup or do i need to handle the DB calls any different.
I would really appreciate any suggestions.
Thank you,
Kiran |
|
Back to top |
|
|
sunny_30 |
Posted: Thu Jul 29, 2010 11:34 am Post subject: |
|
|
Master
Joined: 03 Oct 2005 Posts: 258
|
|
Back to top |
|
|
kirankinnu |
Posted: Thu Jul 29, 2010 1:17 pm Post subject: |
|
|
Centurion
Joined: 12 Jun 2004 Posts: 128 Location: Chicago, IL
|
Hi,
I tried adding this but did not work. After adding in workarounds, i even rebooted. but of no use.
Thank you,
Kiran |
|
Back to top |
|
|
|
|
|
|
Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|