Inserting CLOB data with ANT

Question

Hello,

I am trying to use Ant to initialize my Oracle database by using Ant. I followed this guide:

http://www.roseindia.net/tutorials/ant/AntScripttoInsertDatainMysqlTable.shtml

and that works but I was wondering if anyone knows how to insert CLOB data into Oracle tables using Ant.

Thanks in advance.

Answer 1

From what I see in this Ask Tom article, it should be possible to just insert VARCHAR2-values like that:

create table t ( x clob );

insert into t values ( 'MY CLOB CONTENT' );

EDIT
If you want to insert from a file, it should be possible to use the loadfile task to get the file into a property, replace the newlines somehow and use that property in the insert.