how to extract xml file from unix and store(or insert ) in a clob column

please reply!!!!

guys anyone plz help !!

XML file must reside on DB Server system

Which SQL client are you using?

use XMLtype CLOB column can load using an external table

hey guys i have found the solution,,, many thanks for ur reply,, but it worked in a very different way from all ur suggestions..
Neways my wrk was done n the code is wrkin fine,,,

unlike your spellchecker

If you have a solution then post it for the use of other people.

CREATE OR REPLACE PROCEDURE load_clob_data AS
var_file_handle utl_file.file_type;
file_location VARCHAR2(100);
text VARCHAR2(5676);
var_clob CLOB;
BEGIN
file_location := '/ebz/apps/angol';
var_file_handle := utl_file.fopen(file_location, 'test.xml', 'r');
LOOP
BEGIN
utl_file.get_line(var_file_handle, text);
DBMS_OUTPUT.put_line(text);
EXCEPTION
WHEN NO_DATA_FOUND THEN
EXIT;
END;
var_clob := var_clob ||text || CHR(13);
END LOOP;
INSERT INTO clob_tab(datetime_inserted,datetime_start,data) VALUES(to_date('12/12/2011 13:11:15','dd/mm/yyyy hh24:mi:ss'),to_date('12/12/2011 13:10:10','dd/mm/yyyy hh24:mi:ss'),var_clob);
commit;
utl_file.fclose(var_file_handle);
END;
/