Re: Softball (I hope) - Current Directory in SQLPlus
Date: Wed, 18 Dec 2013 21:13:59 +0000
Message-ID: <CED7794D.3C983%Mark.Bobak_at_ProQuest.com>
Hi Ric,
I recall Tom Kyte saying that handling advanced file/directory stuff is better handled in Java. Write a bit of Java code, write a PL/SQL wrapper, and you're in business. (And it should be portable.)
I did a bit of quick searching on AskTom, but I didn't find anything. And I'm not at all a Java guy, so I'm in no position to try to write it myself.
-Mark
From: "ric.van.dyke_at_hotsos.com<mailto:ric.van.dyke_at_hotsos.com>" <ric.van.dyke_at_hotsos.com<mailto:ric.van.dyke_at_hotsos.com>> Reply-To: "ric.van.dyke_at_hotsos.com<mailto:ric.van.dyke_at_hotsos.com>" <ric.van.dyke_at_hotsos.com<mailto:ric.van.dyke_at_hotsos.com>> Date: Wednesday, December 18, 2013 at 4:04 PM To: "Radoulov, Dimitre" <cichomitiko_at_gmail.com<mailto:cichomitiko_at_gmail.com>>, "oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: RE: Softball (I hope) - Current Directory in SQLPlus
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<mailto: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-l
Received on Wed Dec 18 2013 - 22:13:59 CET