OraFAQ Forum: Forms » Parameters

Home » Developer & Programmer » Forms » Parameters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Parameters [message #300138]

Thu, 14 February 2008 06:13

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

Report message to a moderator

Re: Parameters [message #300307 is a reply to message #300138]

Thu, 14 February 2008 23:31

sasipalarivattom
Messages: 121
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

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

Report message to a moderator

Re: Parameters [message #300717 is a reply to message #300560]

Sun, 17 February 2008 22:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:22:34 CDT 2024