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
|