RE: Softball (I hope) - Current Directory in SQLPlus
From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Wed, 18 Dec 2013 15:04:01 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF0220B5A8_at_WIN02.hotsos.com>
Yea... was just hoping for something "simpler"...also it can't be OS dependent, as in it needs to run in widows, Unix, Linux, bla-bla-bal... Which is why I was looking for something within SQLPlus.
Date: Wed, 18 Dec 2013 15:04:01 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF0220B5A8_at_WIN02.hotsos.com>
Yea... was just hoping for something "simpler"...also it can't be OS dependent, as in it needs to run in widows, Unix, Linux, bla-bla-bal... Which is why I was looking for something within SQLPlus.
From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com] Sent: Wednesday, December 18, 2013 3:58 PM To: Ric Van Dyke; oracle-l_at_freelists.org Subject: Re: Softball (I hope) - Current Directory in SQLPlus
On 18/12/2013 21:53, Ric Van Dyke wrote:
Not an option in this case.
[...]
Generate the create directory command dynamically using the host sqlplus
command, store it in a script
and execute it after that ?
[untested]
host "printf "create or replace directory my_dir as '%s';\n" "$PWD" >
create_dir.sql"
_at_create_dir
...
Regards
Dimitre
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 18 2013 - 22:04:01 CET