Skip to Content
author's profile photo Former Member
Former Member

XI 2.0, JDBC-Adapter and Oracle

Posted on Jul 22, 2004 at 05:01 AM 10 Views

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

SAP Process Integration
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Andrzej Filusz
    Andrzej Filusz
    Posted on Jul 22, 2004 at 08:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded