1 2 Previous Next 15 Replies Latest reply: May 25, 2012 4:02 AM by 344384 Go to original post RSS
      • 15. Re: XML Sequence Chars Issue
        344384
        Hi

        I have one more question

        RESP is XMLTYPE;
        RESP := XMLTYPE.CREATEXML (SOAP_RESPOND);
        
        INSERT INTO XXHCC_BARTECSTAGING_XML VALUES (xmltype(SOAP_RESPOND), sysdate,'Street_Events_Get SOAP Response' );
        Commit;
          
        RESP := RESP.EXTRACT('/soap:Envelope/soap:Body/child::node()','xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"');
        
        
          IF RESP.ExistsNode('//Streets_Events_GetResponse/Streets_Events_GetResult/EventType') = 1 THEN
                 
                 SOAP_RESPOND :=  XMLTYPE(SOAP_RESPOND).EXTRACT('/soap:Envelope/soap:Body/Streets_Events_GetResponse/Streets_Events_GetResult/text()'
                                            , 'xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/",
                                               xmlns="http://xxi/"').GETCLOBVAL();
                  
                  Xml_Result := XMLTYPE(DBMS_XMLGEN.CONVERT(SOAP_RESPOND, DBMS_XMLGEN.ENTITY_DECODE));
                  
                  INSERT INTO XXHCC_STAGING_XML VALUES ( Xml_Result, sysdate,'Street_Events_Get SOAP Response' );
                  Commit;
        
                  StResult := Xml_Result;                                      
                            
              ELSE
        
                     log_error();
        
              End if;
        When i run the above code, I get the soap response back with the > and < than characters but after it it fails and i get an internal error [] [] [] in sqlplus or method dispatch on NULL SELF argument is disallowed.

        I m tryint to check if a node exists in the soap response and then write to the table the response and do my operation, if not there is a error and log that error.

        I m using the RESP.existsnode and i dont know what is wrong there.

        Can someone let me know,

        Many thanks

        Sri
        1 2 Previous Next