postgresql7.1
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
select case when exists (select 1 from acs_object_types t where t.object_type = :group_type)
then 1
else 0
end