2 Replies Latest reply: May 5, 2009 3:04 PM by Hema Patel RSS

    dbms_xslprocessor.valueOf generates ora-24331

    Hema Patel
      I am using 10.1.0.3.0 Oracle standard database. I am using dbms_xslprocessor to parse document. I get ora-24331.

      FOR rec2 IN 0 .. dbms_xmldom.getLength(l_nl) - 1 LOOP

      l_n := dbms_xmldom.item(l_nl, rec2);

      -- Use XPATH syntax to assign values to he elements of the collection.
           dbms_xslprocessor.valueOf(l_n,'DATA/RECORD_TYPE[1]/text()',rectype);     
           dbms_xslprocessor.valueOf(l_n,'DATA/MAIN_ENTRY[1]/text()',mainentry);     
           dbms_xslprocessor.valueOf(l_n,'DATA/URL[1]/text()',url);          
           dbms_xslprocessor.valueOf(l_n,'DATA/TITLE[1]/text()',title);
           dbms_xslprocessor.valueOf(l_n,'DATA/DESCRIPTION[1]/text()',description);
           dbms_xslprocessor.valueOf(l_n,'DATA/SIMILAR-PAGES-URL[1]/text()',similaPageURL);
           dbms_xslprocessor.valueOf(l_n,'DATA/MUSE_SESSION_UID[1]/text()',musesessionid);     
           dbms_xslprocessor.valueOf(l_n,'IDR/TITLE[1]/text()',IDRTITLE);     
           dbms_xslprocessor.valueOf(l_n,'DATA/MUSE_SESSION_UID[1]/text()',musesessionid);          
           dbms_xslprocessor.valueOf(l_n,'IDR/IDENTIFIER[1]/text()',idr_Identifier);     
           dbms_xslprocessor.valueOf(l_n,'IDR/DESCRIPTION[1]/text()',idr_description);     
                
      INSERT INTO DOJ_DATA(INSTRUCTION_ID , REFERENCE_ID,RESULT_SET_NAME, RECORD_TYPE,MAIN_ENTRY,URL,
                TITLE ,DESCRIPTION,SIMILAR_PAGES_URL,MUSE_SESSION_UID,
                RAWDATA,IDR_TITLE ,IDR_IDENTIFIER ,IDR_DESCRIPTION)
      VALUES(insructionid,ref_id,result_set_name,rectype,mainentry,url,title,description,similaPageURL,
                musesessionid,rawdata,IDRTITLE,idr_Identifier,idr_description);                                                                                      
           
      commit;

      END LOOP;

      dbms_xmldom.freeDocument(doc);
      dbms_xmlparser.freeParser(l_parser);