Calling Stored Procedure - Cursor SP 16

[Former Member]

I upgraded XI to SP16 so that I can use Cursor. I am calling the stored procedure. No errors. I do not see any data in the Cursor.

I am thinking the stored procedure is returning data but for some reason I am not able to see the result set. Can someone give me a hint as to how JDBC Adapter reads the cursor that is returned or what how I can retrieve data from the cursor?

I tested the stored procedure from a java program and everthing works fine.

Any suggestions welcome.

[Former Member]

Hi Michael,

Please check the SAP Note <a href="https://websmp103.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=941317&_NLANG=E">941317</a>

This is a fragment:

<i>

Oracle Database 10g 10.1.x JDBC Driver

"Invoking Oracle stored procedures from within a JDBC sender channel is not supported as Oracle does not return a ResultSet in response to the query."

.

.

.

Oracle Database 10g 10.2.x JDBC Driver

Invoking Oracle stored procedures from within a JDBC sender channel is only possible for Oracle DBMS versions >= 10.2.x using so-called table functions</i>

Regards,

Luis Diego.

[Former Member]

I am using Receiver JDBC Adapter