Oracle Database Discussions

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.;