Re: Path of forms

Scott wrote:
>
> G'day
>
> I have a global variable that stores the path of the location of all my
> forms.
>
> If I hardcode this into my forms, and the location of these files
> changes, I'm stuffed.
>
> Does anyone know a way to get the path of a directory at runtime.
>
> I can't figure out how to do it using host, or the get_environment
> function.
>
> Thanks.

Don't use any paths at all, and then you can just use FORMSxx_PATH environment variable and/or ORACLE_PATH to control where things are found ...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy