Skip to Main Content

I can't make SOAP request with apex_web_service.make_request, I got "PLS-00382: expression is of wr

GeekintoMar 7 2019 — edited Mar 7 2019

Hi All,

DB: 18c Standard Edition 2 Release 18.0.0.0.0

Using: SQLDev 18.4

have this function pkg_file.get_xml_clob returns  XML clob.

I have SOAP URL http://192.168.1.83/CmcGlm/Fileinhlh.svc to post this XML Clob to it.

So when i execute the next code i got this error

Error report -
ORA-06550: line 19, column 19:
PLS-00382: expression is of wrong type
ORA-06550: line 19, column 9:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.

I need your help please,

Thanks in advance

set SERVEROUTPUT ON

declare

    l_clob      clob;

    l_resp      clob;

begin

        l_clob := pkg_file.get_xml_clob(p_file_id =>7570);

       

        l_clob := '<?xml version="1.0" encoding="UTF-8"?>

                    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"

                      xmlns:xs="http://www.w3.org/2001/XMLSchema">

                      <soap:Body>'

                        || l_clob ||

                      '</soap:Body>

                    </soap:Envelope>';

                                       

        l_resp := apex_web_service.make_request(p_url         => 'http://192.168.1.83/CmcGlm/Fileinhlh.svc',

                                                p_envelope        => l_clob );  

    dbms_output.put_line(to_char(l_resp));

end;

Comments
Post Details
Added on Mar 7 2019
2 comments
375 views