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

Lots of potential problems and security worries ... 

https://forums.oracle.com/thread/2191796
 

________________________________
 From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
To: Mark Bobak <Mark.Bobak_at_proquest.com>; "Radoulov, Dimitre" <cichomitiko_at_gmail.com>; oracle-l@freelists.org 
Sent: Wednesday, December 18, 2013 4:17 PM
Subject: RE: Softball (I hope) - Current Directory in SQLPlus
  


Yea I drink Java I don’t write it.  
 
This seems way to simple to have to invoke Java and the like. 
 
From:Mark Bobak [mailto:Mark.Bobak_at_proquest.com] 
Sent: Wednesday, December 18, 2013 4:14 PM
To: Ric Van Dyke; Radoulov, Dimitre; oracle-l_at_freelists.org
Subject: Re: Softball (I hope) - Current Directory in SQLPlus
 
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" <ric.van.dyke@hotsos.com>
Reply-To: "ric.van.dyke_at_hotsos.com" <ric.van.dyke@hotsos.com>
Date: Wednesday, December 18, 2013 at 4:04 PM
To: "Radoulov, Dimitre" <cichomitiko_at_gmail.com>, "oracle-l@freelists.org" <oracle-l@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
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