camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From imranrazakhan <imranrazak...@gmail.com>
Subject Oracle Function Calls with Camel-sql 2.19.0
Date Tue, 23 May 2017 21:26:24 GMT
Hi,

Can we call Oracle Function with camel-sql? its working fine for Store
Procedure but throwing error for functions


 Exhausted after delivery attempt: 1 caught: org.springframework.jdb
c.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call
GET_PREPOST_STATUS(?, ?, ?, ?)}]; nested
 exception is java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00221: 'GET_PREPOST_STATUS' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Following works for store procedure 

from("timer://foo?fixedRate=true&period=20000") 
		.setHeader("msisdn",simple("XXXX"))
		 .to("sql-stored:GET_PREPOST_STATUS(VARCHAR ${header.msisdn},OUT VARCHAR
PREPOST_PAID, OUT VARCHAR STATUS, OUT VARCHAR IS_CORP)?dataSource=myDS")
		 .to("log:input")
		 .end();




--
View this message in context: http://camel.465427.n5.nabble.com/Oracle-Function-Calls-with-Camel-sql-2-19-0-tp5800096.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Mime
View raw message