JDBC ADPATER - "Unsupported feature" in XI with CLOB type

[iaki_vila]

Hi experts,

I have 15 patch XI level. In a stored procedure i use an in and out parameter with CLOB type. I get the exception:

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'XXXX'): java.sql.SQLException: Unsupported feature

If i change the type CLOB by VARVHAR in the XI's XML (Design: Integration Buider), all works fine.

The strored procedure has this parameter like CLOB.

My question is

Is not possible to use the CLOB type?

SAP recognize that it, it's possible:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Sorry for my english. Thanks in advance.

[prateek]

Hi,

Please make sure you use the 10.x driver for full stored procedure CLOB support.

A CLOB is a not comparable Datatype in SQL.

Regards,

Prateek

[Former Member]

Hi,

599110 - Data corruption using JDBC and NCLOBs

Regards

Chilla

[iaki_vila]

In the note put "The problem is eliminated with Oracle 9.2.0.3." and I have 9.2.0.8.0 Oracle Version.

Thanks.

[Former Member]

Hi,

It is very much possible to pass the arguments of Stored Procedure as CLOB type.

I have used them myself.

Do check if u are supplying the parameters correctly and the data type as an attribute....

[iaki_vila]

If I change CLOB by VARCHAR, the service works fine. I think, i have contructed the XML correctly.

Thanks.