Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 What should happen during submit? get the item values on the page and its data attributes and compose a JSON stringpass the JSON string to the databasein the database procedure, convert the JSON parameter and compose an URL for the Report Server. Validate values, for example when the Destination Type = FILE, the… Read More »

Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 After posting the SOAP message to the database, we are waiting for the response. The response from the Report Server is wrapped as a <![CDATA[result]]> tag in the SOAP response. If the report has run successfully, this may be an example of the output: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <SOAP-ENV:Body> <ns1:runJobResponse SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="urn:oracle-reports-rwclient-RWWebService"> <return… Read More »

Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 The old stuff First step is to refresh your memory and have a glance at the (good) old Forms interface. I even have a screen print of a client/server environment (6i) which still works under a VM / Windows XP: In Oracle Forms the generic Headstart Report Launch Form looks like this: The… Read More »