RE: Softball (I hope) - Current Directory in SQLPlus

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 18 Dec 2013 23:03:42 +0100
Message-ID: <CAGJBphShRn3yzwgFFueRZTD7Euf3h_d1e+38=bhZSPF+HaScDA_at_mail.gmail.com>

Another simpler option is to use a predefined directory that is almost guaranteed to exists: /tmp or %TEMP% for example (or $HOME %HOMEPATH% if persistent storage is needed).

Regards
Dimitre
 Il 18/dic/2013 22:29 "Ric Van Dyke" <ric.van.dyke_at_hotsos.com> ha scritto:

> Roger that. Maybe it’s just me but this seems like it should be really
> simple.
>
>
>
> I had someone else point out using DBMS_SYSTEM.GET_ENV which is cool but
> I can’t count on access to DBMS_SYSTEM….
>
>
>
> *From:* Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com]
> *Sent:* Wednesday, December 18, 2013 4:14 PM
> *To:* Ric Van Dyke; oracle-l_at_freelists.org
> *Subject:* Re: Softball (I hope) - Current Directory in SQLPlus
>
>
>
> On 18/12/2013 22:04, Ric Van Dyke wrote:
>
> [...] also it can’t be OS dependent, as in it needs to run in widows,
> Unix, Linux, bla-bla-bal…
>
>
> You can get the platform using dbms_utility.port_string and act
> accordingly.
>
>
> Regards
> Dimitre
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 18 2013 - 23:03:42 CET