Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Passing parameters when calling report from form in oracle 10g

twinklin_girlOct 8 2017 — edited Oct 23 2017

Hello,

Please find my code below where I have a parameter also . My question : is this the correct way to pass a parameter from a form to a report ?

Declare

Rep_server  varchar2(1000);
Format varchar2(500);
Login_user varchar2(500);
Report_path   varchar2(1000);

begin

Rep_server = 'http://xpmachine:8889/reports/rwservlet?;
Format := 'deformat=pdf&destype=cache';
Login_user  = '&userid=username/password@db';
Report_path := ' &report=c:\payr004.rdf';

Web.showdocument(rep_server||format||login_user||report_path||'&p_deptno='||:control.deptno,'_blank');

end;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2017
Added on Oct 8 2017
6 comments
2,427 views