SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

check whether an Oracle DIRECTORY contains any files

user640107Jun 22 2017 — edited Jun 22 2017

Using PL/SQL, we periodically dump certain data as files to an Oracle DIRECTORY. This works 100% fine.

The problem we are facing is that using PL/SQL we need to ensure that the DIRECTORY is empty before we start dumping, and can't work out how.

Does anyone know how we might achieve this?

This post has been answered by JuanM on Jun 22 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2017

Added on Jun 22 2017

7 comments

694 views