drop procedure if exists in DB Oracle

Question

Can someone tell me how I can drop a PROCEDURE in Oracle, but just if it exists ?

DROP PROCEDURE IF EXISTS XYZ;

The above does not work.

Answer 1

If your goal is to eliminate error messages in a script, then you can try

begin
   execute immediate 'drop procedure xyz';
exception when others then
   if sqlcode != -4043 then
      raise;
   end if;
end;
/

Answer 2

You can also check dictionary view before:

SELECT * FROM USER_PROCEDURES WHERE PROCEDURE_NAME = 'XYZ'