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

From: Ric Van Dyke <>
Date: Wed, 18 Dec 2013 14:53:40 -0600
Message-ID: <>

Not an option in this case.  

From: Radoulov, Dimitre [] Sent: Wednesday, December 18, 2013 3:53 PM To: Ric Van Dyke; Subject: Re: Softball (I hope) - Current Directory in SQLPlus  

On 18/12/2013 21:48, Ric Van Dyke wrote:

        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?          

why don't you set/export it as shell variable before entering sqlplus?


Received on Wed Dec 18 2013 - 21:53:40 CET

Original text of this message