You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by james555 <lu...@gmx.net> on 2013/12/20 13:55:00 UTC
Oracle Procedure Calls with Camel
is it possible calling Oracle PL/SQL procedure/function calls with camel ?
Since I've read https://issues.apache.org/jira/browse/CAMEL-4725 it should
be fixed in Version 2.12.0 but I couldnt see it in the release notes ?!
If it is already fixed, do you have an example for me ? The Documenttion of
Component jdbc / sql doesn's say anything about it.
--
View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: Oracle Procedure Calls with Camel
Posted by Claus Ibsen <cl...@gmail.com>.
You can try the sql-stored component
https://github.com/apache/camel/blob/master/components/camel-sql/src/main/docs/sql-stored-component.adoc
On Mon, May 22, 2017 at 5:55 PM, btacoder <bt...@gmail.com> wrote:
> hello,
>
> can we call a stored procedure with 0 parameters, if yes, how can we call
> it?
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115p5800033.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
--
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2
Re: Oracle Procedure Calls with Camel
Posted by btacoder <bt...@gmail.com>.
hello,
can we call a stored procedure with 0 parameters, if yes, how can we call
it?
--
View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115p5800033.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: Oracle Procedure Calls with Camel
Posted by Claus Ibsen <cl...@gmail.com>.
Hi
Take a look at camel-mybatis which can call stored procedures. You can
find examples on their project site, and also in SO such as
http://stackoverflow.com/questions/15666856/calling-oracle-stored-procedures-with-mybatis
On Thu, Jul 9, 2015 at 4:19 PM, deekayzain <de...@gmail.com> wrote:
> Thanks Jacek.
>
> your post is using Spring-jpa.
> we dont have any way to call stored procedures in camel-jdbc or camel-sql of
> latest release.
>
>
> Please confirm.
>
> regds,
> deekayzain
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115p5769053.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
--
Claus Ibsen
-----------------
Red Hat, Inc.
Email: cibsen@redhat.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen
hawtio: http://hawt.io/
fabric8: http://fabric8.io/
Re: Oracle Procedure Calls with Camel
Posted by deekayzain <de...@gmail.com>.
Thanks Jacek.
your post is using Spring-jpa.
we dont have any way to call stored procedures in camel-jdbc or camel-sql of
latest release.
Please confirm.
regds,
deekayzain
--
View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115p5769053.html
Sent from the Camel - Users mailing list archive at Nabble.com.
Re: Oracle Procedure Calls with Camel
Posted by jacek szymanski <ja...@gmail.com>.
I don't know whether there is one; perhaps you can use camel-jpa with
EclipseLink (default OpenJPA doesn't support JPA 2.1).
You can use this bean instead:
https://github.com/quephird/camel-stored-procedure though it doesn't
support Oracle arrays or structs as function/procedure arguments/returns.
--js
deekayzain wrote:
> Hi,
>
> can you some body provide working example for calling stored procedure using
> camel copmonent.
>
>
> Thanks in advance.
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115p5768993.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
RE: Oracle Procedure Calls with Camel
Posted by deekayzain <de...@gmail.com>.
Hi,
can you some body provide working example for calling stored procedure using
camel copmonent.
Thanks in advance.
--
View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115p5768993.html
Sent from the Camel - Users mailing list archive at Nabble.com.
RE: Oracle Procedure Calls with Camel
Posted by cy...@barclays.com.
Yes,
Using spring DSL
<setBody>
<simple> exec myStoreProcedure('aaaa')</simple>
</setBody>
<to uri:"JDBC:Datasource" />
Where Datasource is a bean
-----Original Message-----
From: james555 [mailto:luke333@gmx.net]
Sent: Friday, December 20, 2013 7:55 AM
To: users@camel.apache.org
Subject: Oracle Procedure Calls with Camel
is it possible calling Oracle PL/SQL procedure/function calls with camel ?
Since I've read https://issues.apache.org/jira/browse/CAMEL-4725 it should be fixed in Version 2.12.0 but I couldnt see it in the release notes ?!
If it is already fixed, do you have an example for me ? The Documenttion of Component jdbc / sql doesn's say anything about it.
--
View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115.html
Sent from the Camel - Users mailing list archive at Nabble.com.
_______________________________________________
This message is for information purposes only, it is not a recommendation, advice, offer or solicitation to buy or sell a product or service nor an official confirmation of any transaction. It is directed at persons who are professionals and is not intended for retail customer use. Intended for recipient only. This message is subject to the terms at: www.barclays.com/emaildisclaimer.
For important disclosures, please see: www.barclays.com/salesandtradingdisclaimer regarding market commentary from Barclays Sales and/or Trading, who are active market participants; and in respect of Barclays Research, including disclosures relating to specific issuers, please see http://publicresearch.barclays.com.
_______________________________________________
Re: Oracle Procedure Calls with Camel
Posted by Claus Ibsen <cl...@gmail.com>.
Hi
CAMEL-4725 is not implemented in any Camel version.
We love contributions, so anyone can help implement the logic needed.
You can use camel-mybatis as MyBatis support stored procedures
http://camel.apache.org/mybatis
On Fri, Dec 20, 2013 at 1:55 PM, james555 <lu...@gmx.net> wrote:
> is it possible calling Oracle PL/SQL procedure/function calls with camel ?
> Since I've read https://issues.apache.org/jira/browse/CAMEL-4725 it should
> be fixed in Version 2.12.0 but I couldnt see it in the release notes ?!
>
> If it is already fixed, do you have an example for me ? The Documenttion of
> Component jdbc / sql doesn's say anything about it.
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Oracle-Procedure-Calls-with-Camel-tp5745115.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
--
Claus Ibsen
-----------------
Red Hat, Inc.
Email: cibsen@redhat.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen
Make your Camel applications look hawt, try: http://hawt.io