MQSeries.net :: View topic - Doubt on executing a Oracle procedure in 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 » Doubt on executing a Oracle procedure in ESQL.

Doubt on executing a Oracle procedure in ESQL.

« View previous topic :: View next topic »

Author

Message

kash3338

Posted: Mon May 04, 2009 9:56 pm Post subject: Doubt on executing a Oracle procedure in ESQL.

Shaman

Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India

HI,

I have to execute a Oracle procedure from ESQL, how do i do that?

For example through SQL, we can execute a procedure through the "exec <Procedure Name>" command, how i do that through ESQL?

Any suggestions would be very helpful.

AkankshA

Posted: Mon May 04, 2009 10:51 pm Post subject:

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

did u read infocenter ??

To invoke a procedure that is stored in a database, use the ESQL CALL statement. The stored procedure must be defined by a CREATE PROCEDURE statement that has:
A Language clause of DATABASE
An EXTERNAL NAME clause that identifies the name of the procedure in the database and, optionally, the database schema to which it belongs.

hint : http://publib.boulder.ibm.com/infocenter/wbihelp/v6rxmx/topic/com.ibm.etools.mft.fp8.doc/ac17040_.htm
_________________
Cheers

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Doubt on executing a Oracle procedure in 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