You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@camel.apache.org by VadimSPB <va...@gmail.com> on 2011/11/29 13:09:22 UTC

call Oracle Package procedure

Hi All,
I can use camel for message transfer in Oracle? Call stored procedure in,
out parameters?
example:
        RouteBuilder route = new RouteBuilder() {
                @Override
                public void configure() throws Exception {
                    from("servlet:///MessageServlet")
                    .setBody(constant("{ CALL
IBS.\"Z$IMS_INTERFACE_WS\".TEST_STR(:P_STR_IN,:P_STR_OUT)}")).to("jdbc:IBSO");                       
                }
            };
thanks 

p.s. I am sorry for my English, I use the translator

--
View this message in context: http://camel.465427.n5.nabble.com/call-Oracle-Package-procedure-tp5032133p5032133.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: call Oracle Package procedure

Posted by VadimSPB <va...@gmail.com>.

Thanks. It is assured that it is possibility it will be claimed. Transfer XML
Message in CLOB is a good way for integration with applications on the basis
of Oracle. After transfer XML Message can parsing means PL\SQL and XMLType.

--
View this message in context: http://camel.465427.n5.nabble.com/call-Oracle-Package-procedure-tp5032133p5035250.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: call Oracle Package procedure

Posted by Christian Müller <ch...@gmail.com>.

I raised the JIRA: https://issues.apache.org/jira/browse/CAMEL-4725

Best,
Christian

On Tue, Nov 29, 2011 at 7:54 PM, Omar Atia <om...@its.ws> wrote:

> I also appreciate if you open Jira for it as we need to have this feature .
>
> Thanks,
> Omar atia
> Sent via BlackBerry® from mtc touch
>
> -----Original Message-----
> From: Christian Müller <ch...@gmail.com>
> Date: Tue, 29 Nov 2011 19:24:07
> To: <us...@camel.apache.org>
> Reply-To: <us...@camel.apache.org>
> Subject: Re: call Oracle Package procedure
>
> Hello Vadim!
>
> Unfortunately it's not possible at the moment, but we could support it.
> Du you consider to open a JIRA (new feature) for it at [1]?
>
> [1] https://issues.apache.org/jira/browse/CAMEL
>
> Best,
> Christian
>
> On Tue, Nov 29, 2011 at 1:09 PM, VadimSPB <va...@gmail.com> wrote:
>
> > Hi All,
> > I can use camel for message transfer in Oracle? Call stored procedure in,
> > out parameters?
> > example:
> >        RouteBuilder route = new RouteBuilder() {
> >                @Override
> >                public void configure() throws Exception {
> >                    from("servlet:///MessageServlet")
> >                    .setBody(constant("{ CALL
> >
> >
> IBS.\"Z$IMS_INTERFACE_WS\".TEST_STR(:P_STR_IN,:P_STR_OUT)}")).to("jdbc:IBSO");
> >                }
> >            };
> > thanks
> >
> > p.s. I am sorry for my English, I use the translator
> >
> > --
> > View this message in context:
> >
> http://camel.465427.n5.nabble.com/call-Oracle-Package-procedure-tp5032133p5032133.html
> > Sent from the Camel - Users mailing list archive at Nabble.com.
> >
>
>

Re: call Oracle Package procedure

Posted by Omar Atia <om...@its.ws>.

I also appreciate if you open Jira for it as we need to have this feature .

Thanks,
Omar atia
Sent via BlackBerry® from mtc touch

-----Original Message-----
From: Christian Müller <ch...@gmail.com>
Date: Tue, 29 Nov 2011 19:24:07 
To: <us...@camel.apache.org>
Reply-To: <us...@camel.apache.org>
Subject: Re: call Oracle Package procedure

Hello Vadim!

Unfortunately it's not possible at the moment, but we could support it.
Du you consider to open a JIRA (new feature) for it at [1]?

[1] https://issues.apache.org/jira/browse/CAMEL

Best,
Christian

On Tue, Nov 29, 2011 at 1:09 PM, VadimSPB <va...@gmail.com> wrote:

> Hi All,
> I can use camel for message transfer in Oracle? Call stored procedure in,
> out parameters?
> example:
>        RouteBuilder route = new RouteBuilder() {
>                @Override
>                public void configure() throws Exception {
>                    from("servlet:///MessageServlet")
>                    .setBody(constant("{ CALL
>
> IBS.\"Z$IMS_INTERFACE_WS\".TEST_STR(:P_STR_IN,:P_STR_OUT)}")).to("jdbc:IBSO");
>                }
>            };
> thanks
>
> p.s. I am sorry for my English, I use the translator
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/call-Oracle-Package-procedure-tp5032133p5032133.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>

Re: call Oracle Package procedure

Posted by Christian Müller <ch...@gmail.com>.

Hello Vadim!

Unfortunately it's not possible at the moment, but we could support it.
Du you consider to open a JIRA (new feature) for it at [1]?

[1] https://issues.apache.org/jira/browse/CAMEL

Best,
Christian

On Tue, Nov 29, 2011 at 1:09 PM, VadimSPB <va...@gmail.com> wrote:

> Hi All,
> I can use camel for message transfer in Oracle? Call stored procedure in,
> out parameters?
> example:
>        RouteBuilder route = new RouteBuilder() {
>                @Override
>                public void configure() throws Exception {
>                    from("servlet:///MessageServlet")
>                    .setBody(constant("{ CALL
>
> IBS.\"Z$IMS_INTERFACE_WS\".TEST_STR(:P_STR_IN,:P_STR_OUT)}")).to("jdbc:IBSO");
>                }
>            };
> thanks
>
> p.s. I am sorry for my English, I use the translator
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/call-Oracle-Package-procedure-tp5032133p5032133.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>