DMONIX

index

Function EXISTS_OBJECT


Function Information
Declaration
function        EXISTS_OBJECT(p_object user_objects.object_name%type,
                                         p_type   user_objects.object_type%type) return boolean is
  v_object user_objects.object_name%type;
begin

  select object_name
   into v_object
   from user_objects
    where object_name = upper(p_object)
      and object_type = upper(p_type);

  return true;

  exception
    when no_data_found then
     return false;

end;