by using web.show_document we are bound to put all parameter in address
Look @ code
DECLARE
report_para_list paramlist;
vc_url varchar2(1000);
BEGIN
IF :FDATE IS NULL THEN
SET_ALERT('Enter Value in From Date Field..','Alert');
GO_ITEM('FDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;
IF :TDATE IS NULL THEN
SET_ALERT('Enter Value in To Date Field..','Alert');
GO_ITEM('TDATE');
RAISE FORM_TRIGGER_FAILURE;
END IF;
IF
ARTY IS NULL THEN
SET_ALERT('Enter Value in Party Name Field..','Alert');
GO_ITEM('PARTY');
RAISE FORM_TRIGGER_FAILURE;
END IF;
-----Look @ this Vc_url
vc_url:='
http://lgs:8888/reports/rwservlet?serve ... RAMFORM=NO';
-----Look @ this Vc_url
WEB.SHOW_DOCUMENT(vc_url,'_blank');
NEW_FORM('CB_MAINFORM');
/* This is Forms 6i Code
report_para_list := Create_Parameter_list('TEMP');
Add_Parameter(report_para_list,'FDATE',Text_Parameter,TO_CHAR(TO_DATE(:FDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'TDATE',Text_Parameter,TO_CHAR(TO_DATE(:TDATE,'DD-MON-YYYY'),'DDMMYYYY'));
Add_Parameter(report_para_list,'PARTY',Text_Parameter,:IID);
Add_Parameter(report_para_list, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(Reports,'HAWALA_PARTY_WISE',SYNCHRONOUS,RUNTIME,FILESYSTEM,report_para_list,NULL);
Destroy_Parameter_List(report_para_list);
NEW_FORM('CB_MAINFORM');
This is Forms 6i Code
*/
END;
How can i do more secure the report(adress not shown in address bar)