Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How to use WEB.SHOW_DOCUMENT
How to use WEB.SHOW_DOCUMENT [message #663195] Thu, 25 May 2017 02:19 Go to next message
mashhoodnasir
Messages: 26
Registered: May 2017
Junior Member
i am trying to call report using following statements but fail to generate report. kindly help me where i am doing wrong.

method:1
=========
declare

a varchar2(2000);

begin

a:=' http://oracle-pc:8889/reports/rwservletserver=empsrv&destype=cache&desformat=pdf&report=e:\reports\test_report.jsp&us erid=system/*****@dsc';
web.show_document(a,'_blank');

end;

i also tried with this but same result:

method:2
=========

declare
a varchar2(2000);
begin

a:= ('/reports/rwservlet?test_report&server=empsrv&paramform=no&module=test_report.rdf');
Web.show_document(a,'_blank');


end;


Re: How to use WEB.SHOW_DOCUMENT [message #663204 is a reply to message #663195] Thu, 25 May 2017 06:40 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In order to run reports, I use dynamic action which has two steps:

1. Execute PL/SQL code:
begin
  :P4_ADMIN_URL := 
    'http://my-ias/reports/rwservlet?' ||
    'my_report_name'                   ||
    '&par_id='          || :P4_ID      ||
    '&par_yyyymm='      || :P4_YYYYMM;
end;

2. Execute JavaScript code:
window.open($x('P4_ADMIN_URL').value);
Previous Topic: Oracle APEX- ORDS with XML as output
Next Topic: Passing encoded url string containing %3A (colon) truncates everting after the last %3A
Goto Forum:
  


Current Time: Thu Mar 28 04:56:04 CDT 2024