create or replace function adam.object_id(i_str in varchar2) return number is
  num number;
begin
  begin
    select object_id
      into num
      from user_objects
     where object_name = upper(i_str);
    return(1);
  exception
    when NO_DATA_FOUND then
      return(NULL);
  end;
end object_id;
/
