| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling Stored Procedure from Graphical Map- IIB |
« View previous topic :: View next topic » |
| Author |
Message
|
| rama_kodam |
 Posted: Mon Nov 18, 2013 2:31 am Post subject: Calling Stored Procedure from Graphical Map- IIB |
 |
|
Newbie
Joined: 21 Mar 2011
Posts: 6
|
Hi,
I have a stored procedure in DB2 which returns a result set. I am trying to call this procedure from a Graphical Map. But i am getting the below exception.
Text:CHARACTER:com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10145][10844][3.64.82] Invalid parameter 1: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815
[jcc][10145][10844][3.64.82] Invalid parameter 1: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815
Has anyone able to successfully call stored procedure from Graphical Map? If yes, could you please help? |
|
| Back to top |
|
 |
| martinb |
| Posted: Fri Dec 13, 2013 8:58 am Post subject: |
|
|
Master
Joined: 09 Nov 2006
Posts: 210
Location: UK
|
The error you are receiving is the database rejecting the data you mapping is providing to the Stored Proceedure
SQLSTATE=42815 The data type, length, scale, value, or CCSID is invalid.
Please review your mapping in this respect. |
|
| 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
|
|
|
|
