MQSeries.net :: View topic - Execute Oracle Sequence from a different DSN 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 » Execute Oracle Sequence from a different DSN in compute node

Execute Oracle Sequence from a different DSN in compute node

« View previous topic :: View next topic »

Author

Message

saurabh867

Posted: Sun Jun 13, 2010 3:36 am Post subject: Execute Oracle Sequence from a different DSN in compute node

Voyager

Joined: 13 Jun 2010
Posts: 78

Hi,
I have to call an oracle sequence from compute node. This sequence lies in a different schema from the one given in compute node.
How can I execute it ? I am able to access the tables of this schema by giving DSN and schema name like : Database.{DSN}.{SCHEMA}

Gaya3

Posted: Sun Jun 13, 2010 5:54 am Post subject:

Jedi

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

there is a function called passthru, make use of it,

similar kind of question have been discussed in this forum a lot.

do a search too
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Execute Oracle Sequence from a different DSN 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