MQSeries.net :: View topic - Problem calling Oracle 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 » Problem calling Oracle stored procedure

Problem calling Oracle stored procedure

« View previous topic :: View next topic »

Author

Message

MikeTamari

Posted: Wed Dec 10, 2003 5:57 am Post subject: Problem calling Oracle stored procedure

Apprentice

Joined: 04 Feb 2002
Posts: 26

When calling a stored procedure in Oracle, and declaring it, as desribed in the ESQL reference, do I need to configure anything in the INPUT PANE so that the node can refer to the procedure. I tried putting the DB name and the procedure name but it doesnt work.

When I ran the sample exactly as it is in the PDF it doesnt work, I keep getting ORA 24328: illegal attribute value.

I am using WMQI 2.1 CSD 2 on Win2000.

Thanks.

mgk

Posted: Wed Dec 10, 2003 6:11 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

You need to specify the datasource on the node, and also the package if the procedure is in an Oracle Package, as in EXTERNAL NAME 'MySchema.MyPackage.MyProcedure'
_________________
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 » Problem calling Oracle stored procedure

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