Home > IT Answers > Oracle > Call parameter from Oracle Reports 10g web.sh...
Superad
35 pts.
0
Q:
Call parameter from Oracle Reports 10g web.show_doc
Web.Show_Document, Oracle Forms 10g, Oracle 10g, Oracle development
the code DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:='/reports/rwservlet?'
||'&report=c:\testrpt10g.rdf'
||'&desformat=htmlcss&destype=cache'
||'&userid=stlexport/stlexpst@as';
WEB.SHOW_DOCUMENT(rep_url,'_blank');
END; is running well. But now i want the report's parameter form to be displayed. How can i do this using web.show_document(...)
ASKED: May 15 2009  9:20 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Superad
35 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Dont bother for writing long codes. if you want the report's parameter from to display then just write the following amended code. Read it carefully.
DECLARE
rep_url varchar2(2000);
BEGIN

 rep_url:='/reports/rwservlet?'
 ||'&report=c:\testrpt10g.rdf'
 ||'&desformat=htmlcss&destype=cache'
 ||'&userid=username/password@databaseparamform=yes';
 WEB.SHOW_DOCUMENT(rep_url,'_blank');
 END;
 
 
 good luck
 Rashid Shah
Last Answered: May 19 2009  11:31 AM GMT by Superad   35 pts.
Latest Contributors: Carlosdl   29350 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29350 pts.  |   May 19 2009  7:06PM GMT

Easy enough, and your security has been compromised…

 
0