How to call Cloud Report on ExternalReportWSSService from Oracle database?

Question

Hi All We've created a custom report on Cloud and I'm able to invoke it through ExternalReportWSSService using SOAP UI. Now I want to integrate the webservice into APEX application. I'm calling using apex_web_service.Make_request. I gave p_url as https:///xmlpserver/services/ExternalReportWSSService Below is the code. DECLARE v_envelope CLOB; v_xml XMLTYPE; v_result_val VARCHAR2(10); BEGIN apex_web_service.g_request_headers.delete; apex_web_service.g_request_headers (1).name := 'Content-Type'; apex_web_service.g_request_headers (1).VALUE := 'application/soap+xml'; v_envelope := ' /Custom/Interfaces/ContractDataExtractReport.xdo -1 '; v_xml := apex_web_service.Make_request (p_url => 'https:///xmlpserver/services/ExternalReportWSSService' , p_action => 'runReport', p_version => '1.2', p_envelope => v_envelope, p_username => 'user', p_password => 'pwd' ); IF v_xml IS NOT NULL THEN dbms_output.Put_line('v_xml=' || v_xml.Getclobval()); ELSE dbms_output.Put_line('No response'); END IF; END; I'm getting No response from the above code. What should be the value for p_action? If I don't set content-type in the header and set version 1.2, I get "soap version soap1.2 is not compatable with Content type text/xml" error Please advise. Thanks Ashwin

Peter Birkett · Answer

I've done this previously directly from a database, without using APEX, using UTL_HTTP - being a https request you will need to import the certificates from the source and create an ACL to allow the database to access the site. I recently destroyed my VM that I had my development work on (for destroyed, read accidently lost it). Though I am revisiting this soon. Retrieving data directly from a cloud instance and importing into local database tables is very quick, although you will need to decode the data since it will be returned encoded.

This thread is rather old, but, if there is some interest and you don't already have the answer, I'll fire up a new database the next time I have a few days spare.

Gianni Ceresa · Answer

Random guess: the question is about what parameters to set in an APEX package, how about asking in an APEX category?

OP said the report did work when invoked with webservice, therefore the question is about the new way OP wants to execute the webservice call.

JOHNCHRISTOF · Answer

Hi All,

Does anyone have solve this problem.?

Thank you.