CLOB insertion

[ag_201074]

i have a table in which i have a col whose datatype is clob.
the data that i want 2 store in this col would point to a word file, how can acheive this ?
is it possible to store a pointer in a clob file or it has to be the actual data?
how can i acheive the same using BFILE col??

[chikkodi]

I am not sure about BFILEs. We use CLOB columns to store xml messages. We do it using jdbc. To store a word document, my guess is you would need a blob as a word document is not charcater based.

[miritika]

When u create a table with a clob col. u can store a pointer into that col by using a a function called empty_clob() in the insert statement and later using the functions of dbms_lob package to insert data to the clob column.