OCI Drivers in JDBC receiver

[Former Member]

Hi All,

Brief Scenario: Insert data to CLOB field (source field may be more than 4000kb). Requirement to use OCI drivers in JDBC receiver adapter.

When calling Stored Procedure to insert CLOB data field, exception thrown by AE or Oracle server:

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SP_ORDERS' (structure 'STATEMENT'): java.sql.SQLException: ORA-00932: inconsistent datatypes: expected %s got %s

I want to confirm whether SAP support OCI drivers using Stored Procedure?.

Thanks,

Rajesh Yallabandi

[Former Member]

Not solved... work around alternate solution.

Edited by: sappi71 on Jun 20, 2011 10:38 PM