MQSeries.net :: View topic - External Stored Procedure

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 » External Stored Procedure - parameterise

External Stored Procedure - parameterise

« View previous topic :: View next topic »

Author

Message

Vijay_d

Posted: Mon Sep 29, 2008 9:20 am Post subject: External Stored Procedure - parameterise

Apprentice

Joined: 09 Oct 2006
Posts: 26
Location: LONDON

Hi,

How do i parameterise the stored procedure name using an external file.

Say i have a a set of stored procedures in oracle and would want to call it one at a time from ESQL

I may need to call different store proc by changing the name and then testing it. I wouldnt like to change it inside the esql file.

I do remember doing it long back but cant recollect what i exactly did.

Can somebody recollect my memory

Thanks
Vj

Vijay_d

Posted: Mon Sep 29, 2008 9:41 am Post subject:

Apprentice

Joined: 09 Oct 2006
Posts: 26
Location: LONDON

i think i did it this way..

CREATE PROCEDURE myProc(IN p1 CHAR) EXTERNAL NAME "%.myProc";

and then call by

CALL myProc('HelloWorld') EXTERNAL SCHEMA 'file location';

is that how we do?? i may be wrong completly but do help on how to call dynamically from an external file.

Thanks

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » External Stored Procedure - parameterise

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