There is no simple SQL or PL/SQL code to list Oracle directory object contents. None of methods are perfect. Perhaps, ocp might detect which database objects are accessible to the logged user and use any of them.
Help wanted: please add other possible alternatives to the listed below
List directory contents (-ls DIRECTORY option)
There is no simple SQL or PL/SQL code to list Oracle directory object contents. None of methods are perfect. Perhaps, ocp might detect which database objects are accessible to the logged user and use any of them.
Help wanted: please add other possible alternatives to the listed below
DBMS_BACKUP_RESTORE and X$KRBMSFT
http://www.morganslibrary.org/hci/hci002.html
Self made stored procedure written in Java
https://asktom.oracle.com/pls/asktom/f?p=100:11:0%3a%3a%3a%3aP11_QUESTION_ID:439619916584
Known Java framework
http://sourceforge.net/projects/oracle-jutils
External tables
http://www.oracle-developer.net/display.php?id=513
External Procedure in C