By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,279 Members | 1,629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,279 IT Pros & Developers. It's quick & easy.

Insert CLOB data (XML file)

P: n/a
I need some help....

I have XML files residing on the database server harddisk. I want to
load those files as CLOB into a table column. The table is defined like
this:

Table_0 (
ID INT
FILE_DATA CLOB
)

I cannot use application to load it... I want to use unix scripting and
sql to convert XML files to CLOB and insert into the table.

Please help me out. Thanks.

Aug 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I figured out an easy way to do it...
an*************@gmail.com wrote:
I need some help....

I have XML files residing on the database server harddisk. I want to
load those files as CLOB into a table column. The table is defined like
this:

Table_0 (
ID INT
FILE_DATA CLOB
)

I cannot use application to load it... I want to use unix scripting and
sql to convert XML files to CLOB and insert into the table.

Please help me out. Thanks.
Aug 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.