OraFAQ Forum: Forms » opening html file made in sql plus from oracle forms

Home » Developer & Programmer » Forms » opening html file made in sql plus from oracle forms

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

opening html file made in sql plus from oracle forms [message #125263]

Fri, 24 June 2005 02:19

harmeet.gambhir
Messages: 30
Registered: June 2005

Member

hi everybody..

i have a html file(report) created in sql plus.

i want to open this html file from a button in oracle forms..
what is the code to be written in the button pressed trigger..

pl. help me..

thanks in advance..

harmeet

Report message to a moderator

Re: opening html file made in sql plus from oracle forms [message #125409 is a reply to message #125263]

Fri, 24 June 2005 17:26

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Isn't that WEB_SHOW_DOCUMENT?

MHE

Report message to a moderator

Re: opening html file made in sql plus from oracle forms [message #125432 is a reply to message #125263]

Sat, 25 June 2005 03:00

misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india

Senior Member

USE host('iexplorer.exe c:\your_html_file_path.html')
OR
USE web.show_document('document path');

Report message to a moderator

Re: opening html file made in sql plus from oracle forms [message #125437 is a reply to message #125263]

Sat, 25 June 2005 05:46

harmeet.gambhir
Messages: 30
Registered: June 2005

Member

thanks for the reply maaher and misragopal

when i use
USE host('iexplorer.exe c:\your_html_file_path.html')
it opens a command prompt window which closes by itself and there is no other action and
when i use web.show_document, it shows a error and immediately moves to page not found window in internet explorer.

actually i'm facing problems formatting reports in oracle reports, so what i want to do is to somehow create a html report in sql plus which accepts a parameter(as i think formatting is easier in sql plus and modifications are easier).

pl. help.

thanks in advance.

harmeet

Report message to a moderator

Re: opening html file made in sql plus from oracle forms [message #129688 is a reply to message #125437]

Tue, 26 July 2005 04:58

misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india

Senior Member

HI Harmeet,
If command prompt window opened and closed by itself means
either ur IEXPLORE.EXE is not in default position or your HTML file is not it that path.
1. verify html file name.
2. user iexplorer.exe's full path.

for example :
host('c:\Program Files\Internet Explorer\IEXPLORE.EXE c:\your.html');

it workes.

Report message to a moderator

Previous Topic:	tab navigation fails
Next Topic:	calling exe from report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:12:58 CDT 2024