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