How to call Cloud Report on ExternalReportWSSService from Oracle database?

A2k

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://<host_name>/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 := '<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">

<soap:Header/> <soap:Body> <pub:runReport> <pub:reportRequest>

<pub:reportAbsolutePath>/Custom/Interfaces/ContractDataExtractReport.xdo</pub:reportAbsolutePath>

<pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>

</pub:reportRequest></pub:runReport> </soap:Body> </soap:Envelope>';

v_xml := apex_web_service.Make_request (p_url =>

'https://<host_name>/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

User_0UM4P

Hi Ashwin,

I am also in same boat :-( do you have any solution for this?

Thanks in advance.

Prchirum

JOHNCHRISTOF

Hi All,

Does anyone have solve this problem.?

Thank you.

Gianni Ceresa

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.

Peter Birkett

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.