Skip to Content
0
Former Member
Dec 02, 2008 at 09:11 PM

Problem with Stored procedure in JDBC Synch scenario

24 Views

Hello Experts,

I am working on the scenario which is from HTTP <-> to <-> JDBC. It is a synchronouse scenario. We are using Stored procedure in this scenario.

1) Please send the response structure for it.

2) here when i am sending request to the Database it is giving me below error :

Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TCS.PKG_BMF_MANAGE_SERVICE_DATA.PROC_GET_ACTIVE_MF_ESIIDS' (structure 'statement'): java.sql.SQLException: Oracle CLOB Helper: java.lang.AbstractMethodError: java/sql/Clob.setString(JLjava/lang/String;)I. Setting message to status failed.

One of the field in Database stored procedure is of type CLOB. So can you ppl guide me that what might be the solution for this.

Any help appriciated.

Thanks,

Hetal