Softball (I hope) - Current Directory in SQLPlus

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Wed, 18 Dec 2013 14:48:27 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF0220B5A2_at_WIN02.hotsos.com>

I thought this would be easy but I'm not figuring it out nor am I able to find it in all my searching.  

I want to create a directory for the current directory. I want to do this programmatically in SQLPlus with or without PL/PQL is fine.  

CREATE OR REPLACE DIRECTORY SQL_FILE_LOCATION AS <current directory here>;  

It doesn't appear to be in SYS_CONTEXT.  

Yes I know I can do a HOST CD in SQLPlus to see the current directory, but how to I put the output of that that into the CREATE command?  

Thanks!  

+--+--+--+--+--+--+--+--+--+--+--+--+--+--+

Ric Van Dyke

Education Director

Hotsos Ltd.  

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

Received on Wed Dec 18 2013 - 21:48:27 CET