OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » How to use WEB.SHOW

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How to use WEB.SHOW_DOCUMENT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use WEB.SHOW_DOCUMENT [message #663195]

Thu, 25 May 2017 02:19

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;

Report message to a moderator

Re: How to use WEB.SHOW_DOCUMENT [message #663204 is a reply to message #663195]

Thu, 25 May 2017 06:40

Littlefoot
Messages: 21517
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);

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 15:35:59 CST 2019