I am attempting to call an Oracle stored procedure from Spring integration. I have a pooled connection to my database and am using an inbound channel adapter to retreive the data from a select query as follows:
My query takes a cursor as an outbound parameter and will return a result set. The query works in Spring MVC elsewhere in the project.
skip-undeclared-results="true" channel="channel1" id="SP_JDBC"
direction="OUT" type="INTEGER" />
<int-jdbc:returning-resultset name="rows" row-mapper="myRowMapper" />
I keep getting errors saying my parameters are invalid. I've tried googling, but there doesn't seem much in the way of examples, if any. Am I defining the curosr the correct way? Or is it best to use a different sort of gateway/channel-adapter and call the stored-proc from Java?