MQSeries.net :: View topic - Can any one tell me how to deal DB resultsets in MB 5.0

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 » Can any one tell me how to deal DB resultsets in MB 5.0

Can any one tell me how to deal DB resultsets in MB 5.0

« View previous topic :: View next topic »

Author

Message

gm_naren2001

Posted: Wed Aug 15, 2007 2:23 am Post subject: Can any one tell me how to deal DB resultsets in MB 5.0

Newbie

Joined: 27 Apr 2007
Posts: 6
Location: India

Hi,

My requirement is to create a procedure to a Oracle stored procedure that returns a resultset in MB 5.0. In 5.0 DYNAMIC RESULT SET keyword is showing error when creating a procedure to return result.

Can anyone help?

Thanks in advance.

_________________
thank you

mgk

Posted: Wed Aug 15, 2007 3:22 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

DYNAMIC RESULT SET is for V6 only. There is a convoluted way to get back a single result set on V5 for Oracle using PASSTHRU. Contact IBM Service for details, they have a document on it...

Regards,
_________________
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 » Can any one tell me how to deal DB resultsets in MB 5.0

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