ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
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

Post new topic  Reply to topic
 WMB - Accessing Stored Procedures in compute node « View previous topic :: View next topic » 
Author Message
aaron_blade
PostPosted: Fri Jan 01, 2010 6:45 pm    Post subject: WMB - Accessing Stored Procedures in compute node Reply with quote

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..
Back to top
View user's profile Send private message
WMBDEV1
PostPosted: Sat Jan 02, 2010 6:32 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
napier
PostPosted: Mon Jan 04, 2010 2:13 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Gaya3
PostPosted: Mon Jan 04, 2010 9:52 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
ak
PostPosted: Mon Jan 25, 2010 2:52 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
WMBEAI
PostPosted: Mon Jan 25, 2010 4:32 am    Post subject: Reply with quote

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 .
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic 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
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.