Home » Developer & Programmer » Forms » How to open a URL from oracle forms ?
How to open a URL from oracle forms ? [message #547596] Wed, 14 March 2012 23:37 Go to next message
nandhiniprema
Messages: 9
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..
Re: How to open a URL from oracle forms ? [message #547608 is a reply to message #547596] Thu, 15 March 2012 01:05 Go to previous messageGo to next message
Littlefoot
Messages: 19635
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try WEB.SHOW_DOCUMENT
Re: How to open a URL from oracle forms ? [message #547642 is a reply to message #547608] Thu, 15 March 2012 06:16 Go to previous messageGo to next message
owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT
Senior Member
try this


WEB.SHOW_DOCUMENT('http://cnn.com', '_blank');
Re: How to open a URL from oracle forms ? [message #547646 is a reply to message #547642] Thu, 15 March 2012 06:46 Go to previous message
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:
  


Current Time: Mon Sep 22 20:18:42 CDT 2014

Total time taken to generate the page: 0.12136 seconds