Skip to main content
Solved

Delete csv file in database server using custom event

  • Jun 11, 2021 1:44 PM UTC
  • 1 reply
  • 183 views
Malan Jayanka
Sidekick (Employee)
Forum|alt.badge.img+9

Hi,

Can we possible to delete a csv file which is located in database server using a custom event?
File is located in this path.
 


That csv file is created due to migration job failure. But customer needs to delete that file from db server before the next file will be come to db server.

Thank you,
Malan Jayanka

Best answer by Malan Jayanka

Hi,

Solution is found

UTL_FILE.fremove (<directory_name>, <file_name>);

Thank you,
Malan Jayanka

View original
    This topic has been closed for replies.

    1 reply

    Malan Jayanka
    Sidekick (Employee)
    Forum|alt.badge.img+9
    • Malan Jayanka
    • Author
    • Sidekick (Employee)
    • Answer
    • Jun 14, 2021 5:43 AM UTC

    Hi,

    Solution is found

    UTL_FILE.fremove (<directory_name>, <file_name>);

    Thank you,
    Malan Jayanka

      Terms & ConditionsAccessibility statement