oracle8.1.6 select case when exists (select 1 from user_objects o where o.object_type='PACKAGE' and o.object_name = upper(:package_name)) then 1 else 0 end from dual select case when exists (select 1 from acs_object_types t where t.object_type = :group_type) then 1 else 0 end from dual drop package [DoubleApos $group_type] delete from group_type_rels where group_type = :group_type begin acs_object_type.drop_type(:group_type); end; drop table $table_name begin delete from group_types where group_type=:group_type; end; select distinct o.object_id from acs_objects o, acs_object_party_privilege_map perm where perm.object_id = o.object_id and perm.party_id = :user_id and perm.privilege = 'delete' and o.object_type = :group_type