MQSeries.net :: View topic - PASSTHRU('select Esb

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 » PASSTHRU('select Esb_seqnum.nextval from dual');

PASSTHRU('select Esb_seqnum.nextval from dual');

« View previous topic :: View next topic »

Author

Message

kumar.MBMQ

Posted: Mon Dec 16, 2013 3:18 am Post subject: PASSTHRU('select Esb_seqnum.nextval from dual');

Voyager

Joined: 06 May 2011
Posts: 93

I have created the sequence in the db with schema name xe1.
but when I test the message flow is not responding.
flow = mqinput node -> compute -> mqoutputnode .
should I have to mention the schema name while calling the sequence ?

SET OutputRoot.MRM.DATA = PASSTHRU('select Esb_seqnum.nextval from dual');

thanks,

dogorsy

Posted: Mon Dec 16, 2013 3:30 am Post subject:

Knight

Joined: 13 Mar 2013
Posts: 553
Location: Home Office

You probably do. But that is not the cause of the flow not responding. You have not said what database you are using, probably Oracle, nor what WMB version.
You need to run a user trace with the debug option and try to see why your flow is not responding.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » PASSTHRU('select Esb_seqnum.nextval from dual');

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