1 Reply Latest reply: Sep 7, 2012 9:16 AM by Jason_(A_Non) RSS

    Error when parsing XML data that is loaded using SQL Loader

    sumanth.shenoy
      I am loading content of an XML file into a table using SQL loader.
      Below is my Control file script -

      LOAD DATA
      INFILE *
      INTO TABLE xx_cc_response_xml_stg TRUNCATE
      xmltype(XML_DATA)
      FIELDS
      ( COLUMN_ID constant 1,
      file_name filler char(4000),
      XML_DATA LOBFILE(file_name) TERMINATED BY EOF)
      BEGINDATA
      B2B_MasterDataUpdate_20120906152137.xml
      ------------------------------------------------------------------------------------

      The file B2B_MasterDataUpdate_20120906152137.xml is correct and XML is well formed.

      When i try to query for XML_DATA (datatype XMLType) column in the table, i cannot see any content in the record, and it appears as (XMLTYPE)
      When I parse this XML using the below,

      ------------------------------------------------------------------------------------
      select value(d)
      from xxnbn_cc_response_xml_stg a,
      table(xmlsequence(extract(a.xml_data,'/InventorySearch'))) d;
      ------------------------------------------------------------------------------------
      I get this error:
      ------------------------------------------------------------------------------------
      ORA-00600: internal error code, arguments: [qmcxdsSelf4], [], [], [], [], [], [], [], [], [], [], []
      00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
      *Cause:    This is the generic internal error number for Oracle program
      exceptions.     This indicates that a process has encountered an
      exceptional condition.
      *Action:   Report as a bug - the first argument is the internal error number
      ------------------------------------------------------------------------------------

      Any pointers on this highly appreciated !