4 Replies Latest reply: Aug 8, 2007 10:56 AM by 582145 RSS

    How to insert XML file into oracle10g DB?

      I try to insert the CD1.xml into oracle 10g database
      but it returns the errors to me Y_Y

      At first, I had create XML table :

      create table MyCD of XMLType;

      and then insert CD1.XML into MyCD table :

      insert into MyCD
      values(XMLType(bfilename('XMLDIR', 'CD1.XML'), nls_charset_id('AL16UTF8')));

      and the returned errors are :

      ERROR at line 2:
      ORA-22288: file or LOB operation FILEOPEN failed
      The filename, directory name, or volume label syntax is incorrect.
      ORA-06512: at "SYS.DBMS_LOB", line 523
      ORA-06512: at "SYS.XMLTYPE", line 287
      ORA-06512: at line 1

      I never use XML with oracle10g before but I have been train in some of oracle courses.
      Can anyone help me and told what I was wrong?

      Thank you very much

      Kanokporn P.