Is it possible to delete a file (like a leftover CSV that caused a migration job failure) located directly on the database server's filesystem, from inside a Custom Event's PL/SQL?

Q: Is it possible to delete a file (like a leftover CSV that caused a migration job failure) located directly on the database server's filesystem, from inside a Custom Event's PL/SQL?

Yes — use UTL_FILE.fremove( , );, referencing the Oracle DIRECTORY object name that points at the folder containing the file (not the raw filesystem path) along with the file's name. This standard Oracle package procedure deletes the specified file directly from PL/SQL, and can be called from a Custom Event's action just like any other PL/SQL statement — useful for cleaning up a failed migration job's input file before the next file arrives at the same location.

Answer

Yes — use UTL_FILE.fremove(<directory_name>, <file_name>);, referencing the Oracle DIRECTORY object name that points at the folder containing the file (not the raw filesystem path) along with the file's name. This standard Oracle package procedure deletes the specified file directly from PL/SQL, and can be called from a Custom Event's action just like any other PL/SQL statement — useful for cleaning up a failed migration job's input file before the next file arrives at the same location.

← Browse Platform, Aurena, and customization questions