How to pull out the absolute path to developer home in forms builder? [message #144476] |
Wed, 26 October 2005 12:13 |
adamjsawyer
Messages: 79 Registered: April 2005 Location: Perth, Western Australia ...
|
Member |
|
|
I need to pull the absolute path to the oracle developer home inside forms builder at run time (Oracle 9i). This is because my system runs on pcs that have different path installations. Therefore an absolute pathname won't do the trick.
To explain:
I want to save my generated html reports in <DSHOME>\forms90\tools\web90\html. This way I can open them by using the command: WEB.SHOW_DOCUMENT('http://127.0.0.1:8888/forms90/html.report.html','_blank');
I have to use http:// because for some reason file:/// doesn't work in XP SP2, and despite many postings on various forums, noone has even acknowledged the problem, let alone tried to help.
So, if I can find a way to locate the developer home directory, i can just drill down from there and put the reports where I want them to go.
Is there some built-in or property I can check to find this folder name? I can't use REPORTS_PATH or any of those ones because I've had to set them all to a temp directory to make reports builder work.
Thanks
Adam
|
|
|
Re: How to pull out the absolute path to developer home in forms builder? [message #144515 is a reply to message #144476] |
Wed, 26 October 2005 19:41 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Adam,
I don't remember this questionQuote: | I have to use http:// because for some reason file:/// doesn't work in XP SP2, and despite many postings on various forums, noone has even acknowledged the problem, let alone tried to help.
| Does the USE_SHARED_SOCKET=TRUE option mentioned in http://www.orafaq.com/forum/t/52166/67467/ help with this?
Search this forum for 'temp' and 'tmp'. Are any of their solutions applicable to you? The directory pointed to by the 'tmp' and 'temp' environment variables are the only locations to which you can guarantee that the user has write access.
David
|
|
|