DECLARE
	VPASSWORD  VARCHAR2(30);
BEGIN
	
				Declare
				v_show_document	VARCHAR2 (2000) := '/reports/rwservlet?';
				v_connect	VARCHAR2 (200)  := 'userid=scott/tiger@test1';
				v_report_server	VARCHAR2 (50)   := 'rep_tbanner';
				v_report_name	VARCHAR2(100)   := '/u01/banner/inb/TEST/reports/rdf/GSTEST.rdf';
				v_format				VARCHAR2(12)    := 'HTMLCSS';	--	PDF or SPREADSHEET
				begin
				v_show_document := v_show_document
				         || v_connect
				         -- Report server
				         || '&server='
				         || v_report_server
				         -- Report name
				         || '&report='||v_report_name
				         -- Reports parameters
				         || '&destype=CACHE'
				         || '&desformat='||v_format
				         || '&paramform=no'
				         || '&ID='||:KEY_ID;
--				         || '&datefrom='|| :dummy.datefrom;		--Parameter Passed to report
				--         || '&p_my_second_parameter='||:block.my_second_parameter	--Parameter Passed to report
				         --;
				web.show_document(v_show_document);
				end;

END;