call sa_make_object('function', 'DailyInfo.GetCursOnDateXML');
alter function "DailyInfo.GetCursOnDateXML"( "On_date" datetime
)
    returns xml
    url 'http://www.cbr.ru/DailyInfoWebServ/DailyInfo.asmx'
    type 'SOAP:DOC'
    set 'SOAP(OP=GetCursOnDateXML)'
    namespace 'http://web.cbr.ru/';

CREATE OR REPLACE PROCEDURE sp_asc_CB_GetCursOnDate( IN p_date datetime )
RESULT(
    Vname   varchar(255),
    Vnom    int,
    Vcurs   money,
    Vcode   int,
    VchCode char(3)
)

BEGIN
    
DECLARE varXML xml;
        
Set  varXML = "DailyInfo.GetCursOnDateXML"( p_date );

select * from OPENXML( USING VALUE varXML,  '//ValuteCursOnDate')
with (  
        Vname  varchar(255)      'Vname',
        Vnom   int               'Vnom',
        Vcurs  money             'Vcurs',
        Vcode int                'Vcode',
        VchCode char(3)          'VchCode'
        ) dt;
END;

select * from sp_asc_CB_GetCursOnDate('2019-02-05')