need to put data of a file in an element

[kavi98]

Hi ,
I need to put in the contents of a file in an element,
How can i do it ,as i have tried to create a .sql file with a update in it ,but it gives an error.

the contents of the file are large.

Thanks
for the help.

 

[Kenrae]

I think we need more information. What kind of error? What kind of file (text/binary)?
By the way, you can open file in Oracle using the UTL_FILE package...

 

[kavi98]

it is a xml file which needs to be inserted in the element of a table.
thanks

 

[Kenrae]

Oh, I didn't understood you!
You can insert every line of the file separately, using varchar2 type.
Or you can insert the whole file as an only element, then you surely will need the clob type.
Anyway, you'll have to open the file, read it's contents and insert them to the table. You can do that with a procedure.