|
DMONIX |
|
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;
|