dropAnyDbLink.sql

set echo on
set linesize 200
column db_link format a30
column host format a50
SELECT *
  FROM dba_db_links
 WHERE owner = '&1'
       AND db_link = '&2';


CREATE OR REPLACE PROCEDURE  &1..drop_link
AS
BEGIN
   EXECUTE IMMEDIATE 'drop database link &2';
END;
/
show errors

BEGIN
  &1..drop_link;
END;
/

DROP PROCEDURE   &1..drop_link;

quit