ARCS Delete File PL/SQL Block Example

arcs_delete_file_example.sql

DECLARE
  l_file_name        VARCHAR2(100);
  lc_arcs_base_url   CONSTANT VARCHAR2(100) := 'https://<baseURL>/';
BEGIN

  l_file_name := 'AAA.csv';
  
  -- Call PL/SQL Procedure to Call the ARCS Delete REST API.
  arcs_utl_pk.delete_file
   (p_base_url    => lc_arcs_base_url,
    p_file_name   => l_file_name,
    p_file_path   => 'inbox');

  dbms_output.put_line('File ['||l_file_name||'] Deleted from ARCS');

EXCEPTION WHEN OTHERS THEN
  dbms_output.put_line('Error Deleting file from ARCS ['||SQLERRM||']');
END;