MQSeries.net :: View topic - How to pass Row or List or object as IN param to External SP

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 » How to pass Row or List or object as IN param to External SP

How to pass Row or List or object as IN param to External SP

« View previous topic :: View next topic »

Author

Message

Mahender

Posted: Tue Oct 24, 2023 12:59 am Post subject: How to pass Row or List or object as IN param to External SP

Newbie

Joined: 23 Oct 2023
Posts: 1

Dear All,

I have requirement Where I need to call External Oracle SP from ESQL (IBM ACE 11).

But where SP is accepts two IN params, one is CHAR and other is OBJECT/ROW/LIST.

Here is my SP params look like:

Code:

P_USER_NAME VARCHAR2 IN
P_DFF_PREV_SEGMENTS_TBL APPS.MBL_DFF_PREV_SEGMENTS_TBL IN
P_VALUE_SET_VALUES APPS.MBL_APP_PKG.MBL_REF_CUR OUT

How do I need to pass the value to P_DFF_PREV_SEGMENTS_TBL as IN param?

Regards,
Mahender

abhi_thri

Posted: Thu Oct 26, 2023 6:02 am Post subject:

Knight

Joined: 17 Jul 2017
Posts: 516
Location: UK

hi...I'm not sure that it is a viable option as per the documentation - https://www.ibm.com/docs/en/app-connect/11.0.0?topic=statements-create-procedure-statement

'All external procedures have the following restrictions:

A stored procedure cannot be overloaded on the database side. A stored procedure is considered overloaded if there is more than one procedure of the same name in the same database schema. If the integration node detects that a procedure is overloaded, it raises an exception.
Parameters cannot be of the ESQL REFERENCE, ROW, LIST, or INTERVAL data types.'

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to pass Row or List or object as IN param to External SP

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