Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MSSQL Cursor issue

Hi Guys,

we are using JDBC driver to send data from SAP PI 7.1 to MS SQL 2012.
The data is passed as an XML file, as below

<ns0:MTORDER xmlns:ns0="http://order">

  <LOADING_UPDATE>

  <sp_order action="EXECUTE">

  <table>SP_ORDER</table>

  <i_status_load type="VARCHAR">1</i_status_load>

<ordercursor isOutput="TRUE" type="CURSOR"></ordercursor>

  <item isOutput="TRUE" type="CURSOR"></item>

  </sp_biz_order_loading_update>

  </LOADING_UPDATE>

</ns0:MTORDER>

We got following message;

java.sql.SQLException: Unsupported parameter type 'CURSOR' for parameter 'ordercursor' found

I believe that MS JDBC driver should support this.


Is this possible?


PM

Former Member
Not what you were looking for? View more on this topic or Ask a question