SQL & PL/SQL

hello,

how can i create script that drop procedure just if procedure exists ?

i try to use :

DROP PROCEDURE if exists add_fe;

and also :


declare
numOfRows number;
begin
select count(*) into numOfRows from user_source where TYPE='PROCEDURE' and NAME='ADD_FE';
if numOfRows != 0
then
execute immediate
'
drop procedure ADD_FE;
';
end if;
end;

but without success at all.

thank u,
adi damty