Author |
Message
|
aruncg |
Posted: Fri Mar 08, 2013 7:11 am Post subject: Error while invoking Oracle stored procedure in WMB V 8 |
|
|
Novice
Joined: 08 Mar 2013 Posts: 22
|
WMB V8.0.0.1
Database : Oracle 11g
Driver : Websphere Message Broker (8.0.0.1) - Datadirect Technologies 6.0 64 bit Oracle Wire Protocol
I am getting the following error when I try to invoke an oracle stored procedure from a subflow.
'The procedure '&1' with '&2' parameters could not be match with a corresponding Database stored procedure.
I have checked the type of procedure - but this is returning just one result set -so no other IN / OUT params.
And also if i move the same external procedure and the invoke to a compute node in the main flow (for testing ) then it is working. Can you plz help on this issue. |
|
Back to top |
|
 |
fjb_saper |
Posted: Fri Mar 08, 2013 3:54 pm Post subject: Re: Error while invoking Oracle stored procedure in WMB V 8 |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20763 Location: LI,NY
|
aruncg wrote: |
WMB V8.0.0.1
Database : Oracle 11g
Driver : Websphere Message Broker (8.0.0.1) - Datadirect Technologies 6.0 64 bit Oracle Wire Protocol
I am getting the following error when I try to invoke an oracle stored procedure from a subflow.
'The procedure '&1' with '&2' parameters could not be match with a corresponding Database stored procedure.
I have checked the type of procedure - but this is returning just one result set -so no other IN / OUT params.
And also if i move the same external procedure and the invoke to a compute node in the main flow (for testing ) then it is working. Can you plz help on this issue. |
Have you tried "inlining" the subflow (compile time option)?  _________________ MQ & Broker admin |
|
Back to top |
|
 |
aruncg |
Posted: Sat Mar 09, 2013 3:07 am Post subject: |
|
|
Novice
Joined: 08 Mar 2013 Posts: 22
|
Yes - the 'Compile and In-line resources' option has already been choosen in the BAR file... But still it is throwing the same error |
|
Back to top |
|
 |
fjb_saper |
Posted: Sat Mar 09, 2013 9:59 am Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20763 Location: LI,NY
|
Could it be that the db user is missing a schema assignment?  _________________ MQ & Broker admin |
|
Back to top |
|
 |
aruncg |
Posted: Mon Mar 11, 2013 6:22 am Post subject: |
|
|
Novice
Joined: 08 Mar 2013 Posts: 22
|
We found that this is an issue with the WMB V8.0.0.1 . |
|
Back to top |
|
 |
mqjeff |
Posted: Mon Mar 11, 2013 6:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
Is there a specific APAR number associated? |
|
Back to top |
|
 |
aruncg |
Posted: Mon Mar 11, 2013 6:56 am Post subject: |
|
|
Novice
Joined: 08 Mar 2013 Posts: 22
|
|
Back to top |
|
 |
|