Inserting CLOB data with ANT
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 int开发者_如何学JAVAo Oracle tables using Ant.
Thanks in advance.
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.
精彩评论