Can Drop table be done here?

[coolmandba]

Hi all,

Can I do this in a stored procedure?

select count(1) into tablecount from all_tables where owner='ABC' and table_name='XXX;
if (tablecount=1) then
execute immediate 'drop table ABC.XXX;
end if;

Somehow 'drop table ABC.XXX' it's not working!
I didn't get any error message, just that the table is not dropped. Please advise.