MQSeries.net :: View topic - Error while invoking Oracle stored procedure in WMB V 8

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Error while invoking Oracle stored procedure in WMB V 8

Error while invoking Oracle stored procedure in WMB V 8

« View previous topic :: View next topic »

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.

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: 20756
Location: LI,NY

aruncg wrote:

Have you tried "inlining" the subflow (compile time option)?

_________________
MQ & Broker admin

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

fjb_saper

Posted: Sat Mar 09, 2013 9:59 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Could it be that the db user is missing a schema assignment?

_________________
MQ & Broker admin

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 .

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?

aruncg

Posted: Mon Mar 11, 2013 6:56 am Post subject:

Novice

Joined: 08 Mar 2013
Posts: 22

IC83407

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Error while invoking Oracle stored procedure in WMB V 8

Jump to:

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

Protected by Anti-Spam ACP