This discussion is archived
4 Replies Latest reply: May 6, 2012 3:30 AM by Mohammad Shaddad RSS

can not start with PDF

ab*424391*iy Newbie
Currently Being Moderated
hello
i have form build in developer suite10g form builder i need to run report type rdf via this form
i write the next text in button
----------------------------------------------------------------------------------------------------------------
DECLARE
     vv_username VARCHAR2(100);
     USR VARCHAR2(30):=get_application_property(USERNAME);
     PAS VARCHAR2(30):=get_application_property(PASSWORD);
     CONS VARCHAR2(30):=get_application_property(CONNECT_STRING);
     VC_REP_NAME VARCHAR2(100);
     vv_connect VARCHAR2(100);
     URL VARCHAR2(500);

BEGIN
          
     vv_connect := lower(USR)||'/'||lower(PAS)||'@'||lower(CONS);
     select report_path||'erad_rep.rep' into VC_REP_NAME from PROFILE;

     URL := '/reports/rwservlet?report='||VC_REP_NAME||'&userid='||VV_CONNECT||     
     '&destype=CACHE&desformat=pdf&paramform=NO&maximize=yes';
     
     URL := URL ||'&mo='||:x2||'&ye='||:t1;
     
               web.show_document(URL);
END;
------------------------------------------------------------------------------------------------------------------------
so when i trying to press on this button the error display
(you can not start with %pdf)
please how can i fix this error
where i use oracle database 11.1g and forms and reports services each one on a seperate server. under windos2003 server O.S

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points