Can you provide an example project and a testcase so I can reproduce it?
camel-sql unfortunately doesn't support stored procedures at the moment. Thus neither SQL binding supports it. See these JIRAs: https://issues.apache.org/jira/browse/CAMEL-4725, [SWITCHYARD-1925] Add stored procedure support for SQL Gateway Binding - JBoss Issue Tracker
1 of 1 people found this helpful
Although OUT parameter can't be retrieved without CallableStatement support, the stored procedure still should be able to be invoked via PreparedStatement IMO. So I think something is wrong if the databse is not updated with the execution.
Thank you for your responses.
Tomohisa: At this moment it's hard to create a unit test for this one by me, since it connects to an oracle database. I haven't access to stored procedure's source code too.
Inside my example/project I did one mistake and therefore data didn't store in database. I need to call second stored procedure before call myApi.createItem(...) (required internal in my project only).
Currently the data are stored in database but I can't get a result of execution stored procedure.
The stored procedure returns a result of operation (success / failure with error message), but inside my switchyard project I get NULL value always.
The message with error description is very imortant for me when an error occure.
As Tomas pointed out, OUT parameter cannot be retrieved from stored procedure call via sql binding until CallableStatement is supported unfortunately. Sorry for the inconvenience.