ORA-19112: error raised during evaluation:  
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared
ORA-06550: line 1, column 7:

declare 
        otvet             clob;
        otvet_s           XMLTYPE;
        zapros clob;
        begin
        zapros:='<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP-ENV:Header/>
  <S:Body>
    <ns4:exportPaymentDocumentDetails xmlns:ns2="http://www.w3.org/2004/08/xop/include" xmlns:ns3="http://smev.gosuslugi.ru/rev120315" xmlns:ns4="http://front.export.gis.smev.someurl.ru/" xmlns:ns5="http://ru.someurl.smev.gis/dict">
      <ns3:PaymentDocumentDetailsRequest>
        <ns3:UnifiedAccountNumber>11AA223344</ns3:UnifiedAccountNumber>
      </ns3:PaymentDocumentDetailsRequest>
		</ns4:exportPaymentDocumentDetails>
	</S:Body>
</S:Envelope> 
';
     otvet      :=  PAY_test(zapros);
     otvet_s:=XMLTYPE(otvet);
begin
for c in(
with t as (select otvet_s from dual)
select *
 from t, xmltable(xmlnamespaces('http://schemas.xmlsoap.org/soap/envelope/' as "S", 'http://smev.gosuslugi.ru/rev120315' as "ns2", 'http://front.export.gis.smev.someurl.ru/' as "ns3"
,'http://www.w3.org/2004/08/xop/include' as "ns4", 'http://ru.someurl.smev.gis/dict' as "ns5"),
'for $i in S:Envelope/S:Body/ns3:exportPaymentDocumentDetailsResponse/ns2:ExportPaymentDocumentDetails
              return $i/ns2:PaymentDocument' passing otvet_s 
             columns 
                 UnifiedAccountNumber varchar2(250) path 'ns2:UnifiedAccountNumber'
))
loop
insert into XTEST (id_1, id_2, ID) values ('2','2',c.unifiedaccountnumber);

 commit;
 end loop;
return;
end;
end;

CREATE OR REPLACE FUNCTION
(
       req_id       in    number,
       outp         in    clob
        )
        return varchar2 is inp VARCHAR2(4000);
        zapros          clob;
        otvet             clob;
        otvet_s           XMLTYPE;
        PaymentDocumentID VARCHAR2(4000);
        UnifiedAccountNumber VARCHAR2(4000);
        AccountNumber varchar2(4000);
        req number(16);
        req1 number (16);
surname VARCHAR2(4000);
req_id_new           NUMBER(16);
        begin
          select sequence_1.NEXTVAL into req_id_new from dual;
          select sequence_1.NEXTVAL into req from dual;
          select sequence_1.NEXTVAL into req1 from dual;
     zapros     :=     outp;
     
     insert into gis_reqstest values (req_id_new,zapros, null);
     commit;
     otvet      :=  PAY_test(zapros);
     otvet_s:=XMLTYPE(otvet);
     
     update usb_gis_reqstest q
     set q.outp = XMLTYPE(otvet)
     where q.type = req_id_new;
     commit;
     
  
     for c in (select PaymentDocumentID, UnifiedAccountNumber, AccountNumber
 from  xmltable(xmlnamespaces('http://schemas.xmlsoap.org/soap/envelope/' as "S", 'http://smev.gosuslugi.ru/rev120315' as "ns2", 'http://front.export.gis.smev.someurl.ru/' as "ns3"
,'http://www.w3.org/2004/08/xop/include' as "ns4", 'http://ru.someurl.smev.gis/dict' as "ns5"),
'for $i in S:Envelope/S:Body/ns3:exportPaymentDocumentDetailsResponse/ns2:ExportPaymentDocumentDetails
              return $i/ns2:PaymentDocumentID' passing otvet_s 
             columns 
                 PaymentDocumentID varchar2(250) path 'ns2:PaymentDocumentID',
                 UnifiedAccountNumber varchar2(250) path 'ns2:UnifiedAccountNumber',
                 AccountNumber varchar2(250) path 'ns2:AccountNumber')) loop
     
insert into GIS_INFO (id_rec,Id_Req,ID_RECORD,PAYMENTDOCUMENTID,UNIFIEDACCOUNTNumber,ACCOUNTNUMBER)  values 
(req_id_new,req,req1,c.PaymentDocumentID,c.UnifiedAccountNumber,c.AccountNumber);

 commit;
 end loop;
end

<?xml version="1.0" encoding="UTF-8"?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body><ns3:exportPaymentDocumentDetailsResponse xmlns:ns2="http://smev.gosuslugi.ru/rev120315" 
xmlns:ns3="http://front.export.gis.smev.someurl.ru/" xmlns:ns4="http://www.w3.org/2004/08/xop/include" 
xmlns:ns5="http://ru.someurl.smev.gis/dict">
<ns2:ExportPaymentDocumentDetails>
<ns2:PaymentDocument>
<ns2:PaymentDocumentID>11AA223344-01-7072</ns2:PaymentDocumentID>
<ns2:UnifiedAccountNumber>11AA223344</ns2:UnifiedAccountNumber>
<ns2:AccountNumber>111AA223344</ns2:AccountNumber>
<ns2:MCServiceID>11AA223344-01</ns2:MCServiceID>
</ns2:PaymentDocument>
<ns2:PaymentDocument>
<ns2:PaymentDocumentID>11AA223344-01-7066</ns2:PaymentDocumentID>
<ns2:UnifiedAccountNumber>11AA223344</ns2:UnifiedAccountNumber>
<ns2:AccountNumber>11AA223344</ns2:AccountNumber>
<ns2:MCServiceID>11AA223344-01</ns2:MCServiceID>
</ns2:PaymentDocument>
</ns2:ExportPaymentDocumentDetails>
</ns3:exportPaymentDocumentDetailsResponse>
</S:Body>
</S:Envelope>

insert into USB_GISZHKH_INFO_4701 (id_rec,Id_Req,ID_RECORD,PAYMENTDOCUMENTID,UNIFIEDACCOUNTNUMBER,ACCOUNTNUMBER) values

 (req_id_new,req,req1,
(select PaymentDocumentID, UnifiedAccountNumber, AccountNumber
 from  xmltable(xmlnamespaces('http://schemas.xmlsoap.org/soap/envelope/' as "S", 'http://smev.gosuslugi.ru/rev120315' as "ns2", 'http://front.export.gis.smev.someurl.ru/' as "ns3"
,'http://www.w3.org/2004/08/xop/include' as "ns4", 'http://ru.someurl.smev.gis/dict' as "ns5"),
'for $i in S:Envelope/S:Body/ns3:exportPaymentDocumentDetailsResponse/ns2:ExportPaymentDocumentDetails
              return $i/ns2:PaymentDocumentID' passing otvet_s 
             columns 
                 PaymentDocumentID varchar2(250) path 'ns2:PaymentDocumentID',
                 UnifiedAccountNumber varchar2(250) path 'ns2:UnifiedAccountNumber',
                 AccountNumber varchar2(250) path 'ns2:AccountNumber')));