https://drive.google.com/file/d/0BwAVQqYmX0-zMHZiS1F0SVdOMmc/view?usp=sharing
DECLARE
v_clob CLOB := to_clob('xml string from local file'); --pls. download xml file from above url;
stmt NVARCHAR2(500) := 'INSERT INTO TEST(XMLDATA) VALUES(:x)';
BEGIN
EXECUTE IMMEDIATE stmt USING v_clob;
END;
if i use xmltype then i can use XMLType(bfilename('test_dir', 'data.xml'), nls_charset_id('AL32UTF8'))
but i have to use clob to store xml string. because oracle xmltype is unable to parse correctly this xml data.;