OraFAQ Forum: Forms » How to open a URL from oracle forms ?

Home » Developer & Programmer » Forms » How to open a URL from oracle forms ?

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

How to open a URL from oracle forms ? [message #547596]

Wed, 14 March 2012 23:37

nandhiniprema
Messages: 10
Registered: February 2012
Location: Chennai

Junior Member

How to open a URL from oracle forms ?

Select APP_SERVER_URL into p_url
from CA_EXT_INT_PARAM
where FACILITY_ID =facility_id;

SELECT appl_user_password INTO p_user_password
FROM sm_appl_user
WHERE appl_user_id = P_Login_User;

p_url := 'iexplore '|| p_url ||'eBT/jsp/photo_capture_main.jsp?' ||
'&p_patient_id='|| p_patient_id|| '&p_facility_id=' ||
p_facility_id ||'?p_login_user=' ||p_login_user ||
'&ws_no='||'dd'||'&locale='||:parameter.p_language_id;

host(p_url)

Above coding throws a error unable to open a link..

Report message to a moderator

Re: How to open a URL from oracle forms ? [message #547608 is a reply to message #547596]

Thu, 15 March 2012 01:05

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try WEB.SHOW_DOCUMENT

Report message to a moderator

Re: How to open a URL from oracle forms ? [message #547642 is a reply to message #547608]

Thu, 15 March 2012 06:16

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

try this

WEB.SHOW_DOCUMENT('http://cnn.com', '_blank');

Report message to a moderator

Re: How to open a URL from oracle forms ? [message #547646 is a reply to message #547642]

Thu, 15 March 2012 06:46

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

another example


   DECLARE
         rep_url varchar2(2000);
   BEGIN
   rep_url:='/dev60cgi/rwcgi60?server=
             repserv6i&report=
             reptest.rdf'
             ||'&desformat=
             htmlcss&destype=
             cache&userid=
             scott/tiger@orcl'
             ||'&p_deptno=
             10&paramform=no';
 
    WEB.SHOW_DOCUMENT(rep_url,'_blank');
   END;

These all examples would help u now use ability

Enjoy

[Updated on: Thu, 15 March 2012 06:49]

Report message to a moderator

Previous Topic:	get count of line from Client_Text_Io.Get_Line
Next Topic:	NEED HELP, developing a database in oracle form 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 21:58:01 CST 2025