MQSeries.net :: View topic - WMB - Accessing Stored Procedures in compute node

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 » WMB - Accessing Stored Procedures in compute node

WMB - Accessing Stored Procedures in compute node

« View previous topic :: View next topic »

Author

Message

aaron_blade

Posted: Fri Jan 01, 2010 6:45 pm Post subject: WMB - Accessing Stored Procedures in compute node

Apprentice

Joined: 21 Dec 2009
Posts: 29

Hi,

I am trying to get results from Stored Procedure. I am using compute node.

Steps I followed :

Calling StoredProcedure in main module and wrote create storedprodure where I am passing parameters to the procudure.

I am getting the following error:

The procedure '&1' with '&2' parameters could not be match with a corresponding Database stored porocedure.

Can anyone help me out how to get the values from stored procedures.

-Thanks,
Raj..

WMBDEV1

Posted: Sat Jan 02, 2010 6:32 am Post subject:

Sentinel

Joined: 05 Mar 2009
Posts: 888
Location: UK

Why dont you show the stored procedure defintion and the ESQL that calls it? That may help

napier

Posted: Mon Jan 04, 2010 2:13 pm Post subject:

Apprentice

Joined: 09 Oct 2007
Posts: 48
Location: USA

There were different ways to write stored procedure on DB side.
You have to talk with yous DB developer and look at the backend stored procedure.

Gaya3

Posted: Mon Jan 04, 2010 9:52 pm Post subject:

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

are you getting the same error if you execute or call the stored procedure from TOAD/SQL Developer/Command prompt.

Cross check the input parameters data types also.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die

Posted: Mon Jan 25, 2010 2:52 am Post subject:

Apprentice

Joined: 07 Aug 2006
Posts: 48
Location: England

Change your OUT parameters to INOUT especially if you are using MS SQL Server as your database.

WMBEAI

Posted: Mon Jan 25, 2010 4:32 am Post subject:

Acolyte

Joined: 02 Mar 2009
Posts: 66

check the datatypes of ur IN and INOUT parameters.
Check if the arguments you pass for the CALL of the stored procedure matches with the CREATE STORED PROCEDURE .

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB - Accessing Stored Procedures in compute node

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