Oracle Stored Procedures

[edhayes]

Hi all,

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:

        <int-jdbc:stored-proc-inbound-channel-adapter
		data-source="dataSource" expect-single-result="true"
		ignore-column-meta-data="true" is-function="false"
		skip-undeclared-results="true" channel="channel1" id="SP_JDBC"
		stored-procedure-name="myProc" auto-startup="true">
		<int:poller fixed-rate="4000"/>
		<int-jdbc:sql-parameter-definition name="sys_refcursor"
			direction="OUT" type="INTEGER" />
		<int-jdbc:returning-resultset name="rows" row-mapper="myRowMapper" />
	</int-jdbc:stored-proc-inbound-channel-adapter>

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.
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?

Thanks
Ed

[Cleric]

Hello

There is no need to declare <int-jdbc:sql-parameter-definition> for cursors.
You should just map <int-jdbc:returning-resultset> for OUT corsors.

Cheers,
Artem

[edhayes]

Artem,

Thanks. That worked perfectly. No mention of this in the reference manual.

Ed