Toad World® Forums

Oracle Tip: Listing directories on filesystem


#1

Easiest way to list specified path, i found:
1.Install utlbinfile on your schema, so I installed on SYS.
2. create directory with your specified path
create or replace directory as
3. Grant java privs:
begin
dbms_java.grant_permission( , ‘SYS:java.io.FilePermission’, ‘*’, ‘read’ ) ;
end;
4.Eecute list command:
begin
utl_BinFile.list_directory();
end;
5. Results :
select * from NN$FOPS$DIR_LIST

Regards Piter

utlbinfile109.zip (24.4 KB)