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;