Re: Oracle Procedure Calls with Camel

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 wrote: > hello, > > can we call a stored procedure with 0 parameters, if yes, how can we

Re: Oracle Procedure Calls with Camel

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

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 deekayz...@gmail.com wrote:

Re: Oracle Procedure Calls with Camel

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:

RE: Oracle Procedure Calls with Camel

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

Re: Oracle Procedure Calls with Camel

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

Re: Oracle Procedure Calls with Camel

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 luke...@gmx.net wrote: is it

RE: Oracle Procedure Calls with Camel

Yes, Using spring DSL setBody simple exec myStoreProcedure('')/simple /setBody to uri:JDBC:Datasource / Where Datasource is a bean -Original Message- From: james555 [mailto:luke...@gmx.net] Sent: Friday, December 20, 2013 7:55 AM To: users@camel.apache.org Subject: Oracle