MQSeries.net :: View topic - Call 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 » Call oracle stored procedure

Call oracle stored procedure

« View previous topic :: View next topic »

Author

Message

Vijay_d

Posted: Fri Sep 05, 2008 2:55 pm Post subject: Call oracle stored procedure

Apprentice

Joined: 09 Oct 2006
Posts: 26
Location: LONDON

Hi ,

I have a stored procedure written in orcale 10g which will accet one input parameter which is of type array.

How do i call this store proc using esql or any other mode in broker
how do i pass the NAME tag to the oracle stored procedure...

say i have a xml msg
<?xml version="1.0" encoding="UTF-8"?>
<Root>
<Name>
<First>VIJAY</First>
<Last>DURAIRAJ</Last>
</Name>
</Root>

the store proc in oracle is
CREATE OR REPLACE PACKAGE test1
IS
TYPE tab_arr IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER;
PROCEDURE prc_ins (p_arr IN tab_arr);
END;
/
CREATE OR REPLACE PACKAGE BODY test1 IS

PROCEDURE prc_ins (p_arr tab_arr)
IS
BEGIN
FOR i IN p_arr.FIRST..p_arr.LAST
LOOP
INSERT INTO Array_test(temp_name) VALUES (p_arr(i));
END LOOP;
END;
END;
/

let me know ur views

thanks

marcin.kasinski

Posted: Fri Sep 05, 2008 11:04 pm Post subject: Re: Call oracle stored procedure

Sentinel

Joined: 21 Dec 2004
Posts: 850
Location: Poland / Warsaw

You can not do it with ESQL.
You can use JAVA code.
_________________
Marcin

Vijay_d

Posted: Sat Sep 06, 2008 2:38 am Post subject: call oracle stored procedure

Apprentice

Joined: 09 Oct 2006
Posts: 26
Location: LONDON

Ya i came to know that from the documentation.

But how can ESQL doesnt support this function.. when java can do i thought esql shld also be able to do in some way..

iam not a java developer .. so do u how we use it in the JCN.. do u we need to add some api to it?

and anyidea on the ROW data type? does it solve with esql

mgk

Posted: Sat Sep 06, 2008 4:53 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

You can call Stored Procedures from ESQL, just not ones that take arrays as parameters or return values.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

AkankshA

Posted: Mon Sep 08, 2008 12:14 am Post subject: Re: call oracle stored procedure

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

Vijay_d wrote:

But how can ESQL doesnt support this function.. when java can do i thought esql shld also be able to do in some way..

eSQL still does not understand array data type...
_________________
Cheers

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Call 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