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