Home » Developer & Programmer » Forms » Parameters
Parameters [message #300138] Thu, 14 February 2008 06:13 Go to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
Dear All

I have this pl/sql statment
web.show_document(' http://180.11.5.119:8889/reports/rwservlet?report=D:\pp_ORCL\RepInvoiceArabic.JSP&destype=cache&desformat=htmlcss&userid='||:parameter.PR_user_id||'/'||:parameter.PR_user_PW||'@orcl&p1='||:pp.NUMBER1);
in order to send a parameters to a report
the question is
I want to use a parameter instead of (180.11.5.119)(the ip of the server)
how can i do such thing

best regards
Re: Parameters [message #300307 is a reply to message #300138] Thu, 14 February 2008 23:31 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Hi dear,

The question is not much clear for me..
You want to use the code like this?

web.show_document(' :parameter.servlet?report=D:\pp_ORCL\RepInvoiceArabic.JSP&destype=cache
&desformat=htmlcss&userid='||:parameter.PR_user_id||'/'||:parameter.PR_user_PW||'@orcl&p1='||:pp.NUMBER1);



Regards
Sasi..

[Updated on: Thu, 14 February 2008 23:34]

Report message to a moderator

Re: Parameters [message #300560 is a reply to message #300138] Sat, 16 February 2008 00:57 Go to previous messageGo to next message
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
Member
yes exactly
so the ip of the computer that the pl/sql will be changed if we put the form into another computer (i mean the IP will be changed according to the computer that the form exsist on)
best regards
Re: Parameters [message #300717 is a reply to message #300560] Sun, 17 February 2008 22:56 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/m/289345/67467/?srch=reports%2Frwservlet%3F+web.show_document#msg_289345

You don't need to specify the IP address.

David
Previous Topic: Version converstion
Next Topic: How to Play Video in Developer 10g Form
Goto Forum:
  


Current Time: Wed Dec 07 03:00:35 CST 2016

Total time taken to generate the page: 0.05255 seconds