XI 2.0, JDBC-Adapter and Oracle

[Former Member]

Hello together,

at the moment I'm working on a scenario, at this I have to write data in a CLOB-Field of a table in a Oracle 9i database. My problem now is, that I only can write a string with a maximum length of 3000 chars directly in the database. To process longer strings I always write a stored procedure to handle this.

Does anybody know a direct solution.

Thank you,

Oli

[Andrzej_Filusz]

Hi!!!

The database allows direct data insertion of up to 4K of data to a CLOB/BLOB column.

If you want to insert more data into CLOB field in the pure SQL (not in a stored procedure), then you have to do this in two steps:

1. insert a new row into the table.

2. update CLOB field of this just inserted row.

You can specified these two SQL statements by using one of the XML document formats (for outbound JDBC adapter).

Regards,

Andrzej Filusz

[Former Member]

Thank you,

I have implemented this solution and it looks good.

Bye Oli