Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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;

This post has been answered by Pavel_p on Mar 7 2019
Jump to Answer

Comments

Post Details

Added on Mar 7 2019
2 comments
808 views