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.
