| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling StoredProcedure from ICS Maps |
« View previous topic :: View next topic » |
| Author |
Message
|
| voyager |
 Posted: Wed Apr 20, 2005 5:42 pm Post subject: Calling StoredProcedure from ICS Maps |
 |
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
All,
Thank you very much for your support with my previous postings.
I am executing a stored procedure inside the Map(java) in ICS. This SP is executed on SQL Server 2000 DB.
I am getting the following error when one of the parameters are null. But, I have to pass the parameters as null as at least one of the parameters can be null. I have executed the SP from SQL Query Analyzer and got the results.
For example: exec xxxxStoredProcedure '01',10,null,20,null
null: A JDBC error was encountered during an attempt to execute accessor stored procedure accessor xxxxStoredProcedure.
| Quote: |
| [info]:: (SQLState [07009]:[IBM-CrossWorlds][SQLServer JDBC Driver]Invalid parameter binding(s).DB specific error:0) |
Anybody's suggestions greatly appreciated!
Thank you
_________________
voyager |
|
| Back to top |
|
 |
| Ratan |
| Posted: Thu Apr 21, 2005 8:56 am Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
post the part of the java code from your map that is calling the stored procedure.
You will have better luck posting this question on some Java forums.
_________________
-Ratan |
|
| Back to top |
|
|
| voyager |
| Posted: Thu Apr 21, 2005 10:01 am Post subject: |
|
|
Centurion
Joined: 28 Dec 2004
Posts: 127
|
Thank you Ratan,
Will do the same!
_________________
voyager |
|
| 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
|
|
|
|
