utl_file_dir versus create directory

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Thu, 22 Aug 2002 07:24:00 -0800
Message-ID: <F001.004BCAF6.20020822072400@fatcity.com>

in 9.0.2, you can use utl_file commands against directory objects, quickie example:

create directory tmp as '/tmp';
grant write on directory tmp to public;
grant read on directory tmp to public;

declare
  ft utl_file.file_type;

begin
  ft:=utl_file.fopen('TMP','x.gf','w');
  utl_file.put(ft,'X!@#$');
  utl_file.fclose(ft);
end;
/

edit /tmp/x.gf

and no i dont have my utl_file_dir set at all.

joe

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: JOE TESTA
  INET: JTESTA_at_longaberger.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 22 2002 - 10:24:00 CDT