MQSeries.net :: View topic - Problem Calling a Stored Procedure from ESQL

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 » Problem Calling a Stored Procedure from ESQL

Problem Calling a Stored Procedure from ESQL

« View previous topic :: View next topic »

Author

Message

Sabyasachi

Posted: Wed Nov 16, 2005 4:33 am Post subject: Problem Calling a Stored Procedure from ESQL

Newbie

Joined: 16 Nov 2005
Posts: 4

Hi
I am trying to call a stored procedure in ORACEL from ESQL.

There are two possible options.

1. using CALL procedure statement
2.Using Passthru

Problem that i have is the stored procedure returns a multiple result sets. I know if i use paasthru then the constraint is i cna not have OUT parameter while calling the procedure.

Any response to this will be highly appreciated

jefflowrey

Posted: Wed Nov 16, 2005 4:44 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

So, you have a two choices.

And you know one doesn't work.
_________________
I am *not* the model of the modern major general.

mgk

Posted: Wed Nov 16, 2005 5:15 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

The only version of Message Broker that supports multiple result sets is V6. This can also do OUT/INOUT and RETURN values at the same time.

One workaround in earlier versions is to create temporary tables in the stored procedure that represent the result sets, and then use SELECT to get the data after the stored procedure call.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem Calling a Stored Procedure from ESQL

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