ut_metadata.md

UT_METADATA

• Data Types

• Variables

• Exceptions

• FORM_NAME Function

• PACKAGE_VALID Function

• PROCEDURE_EXISTS Function

• DO_RESOLVE Procedure

• DO_RESOLVE-1 Procedure

• GET_SOURCE_DEFINITION_LINE Function

• RESET_SOURCE_DEFINITION_CACHE Procedure

• GET_DBA_VIEW Function

• PACKAGE_EXISTS_IN_CUR_SCHEMA Function

Types

Name	Code	Description
t_cache	type t_cache is table of all_source.text%type;

Variables

Name	Code	Description
end	end if;
end	end if;
return	return l_line;
g_cached_object := null;
l_result	l_result varchar2(128) := lower(a_dba_view_name);
pragma	pragma exception_init(l_invalid_object_name,-44002);
begin	begin l_result := dbms_assert.sql_object_name(l_result);
return	return l_result;
c_current_schema	c_current_schema constant all_tables.owner%type := sys_context('USERENV','CURRENT_SCHEMA');
return	return l_cnt > 0;

Exceptions

Name	Code	Description
end	end if;
end	end if;
return	return l_line;
g_cached_object := null;
l_result	l_result varchar2(128) := lower(a_dba_view_name);
pragma	pragma exception_init(l_invalid_object_name,-44002);
begin	begin l_result := dbms_assert.sql_object_name(l_result);
return	return l_result;
c_current_schema	c_current_schema constant all_tables.owner%type := sys_context('USERENV','CURRENT_SCHEMA');
return	return l_cnt > 0;

FORM_NAME Function

Forms correct object/subprogram name to call as owner.object[.subprogram]

Syntax

function form_name(a_owner_name varchar2, a_object varchar2, a_subprogram varchar2 default null) return varchar2

PACKAGE_VALID Function

Check if package exists and is in a VALID state

Syntax

function package_valid(a_owner_name varchar2, a_package_name in varchar2) return boolean

PROCEDURE_EXISTS Function

Check if package exists and is VALID and contains the given procedure.

Syntax

function procedure_exists(a_owner_name varchar2, a_package_name in varchar2, a_procedure_name in varchar2)
  return boolean

DO_RESOLVE Procedure

Resolves [owner.]object using dbms_utility.name_resolve and returns resolved parts

Syntax

procedure do_resolve(a_owner in out nocopy varchar2, a_object in out nocopy varchar2)

DO_RESOLVE-1 Procedure

Resolves [owner.]object[.procedure] using dbms_utility.name_resolve and returns resolved parts

Syntax

procedure do_resolve(a_owner in out nocopy varchar2, a_object in out nocopy varchar2, a_procedure_name in out nocopy varchar2)

GET_SOURCE_DEFINITION_LINE Function

Return the text of the source line for a given object (body). It excludes package spec and type spec

Syntax

function get_source_definition_line(a_owner varchar2, a_object_name varchar2, a_line_no integer) return varchar2

RESET_SOURCE_DEFINITION_CACHE Procedure

Invalidates package-level cache for source.
Caching is used to improve performance of function get_source_definition_line

Syntax

procedure reset_source_definition_cache

GET_DBA_VIEW Function

Returns dba_... view name if it is accessible, otherwise it returns all_xxx view

Syntax

function get_dba_view(a_dba_view_name varchar2) return varchar2

Parameters

Name	Description
a_dba_view_name	the name of dba view requested

PACKAGE_EXISTS_IN_CUR_SCHEMA Function

Returns true if given object is a package and it exists in current schema

Syntax

function package_exists_in_cur_schema(a_object_name varchar2) return boolean

Parameters

Name	Description
a_object_name	the name of the object to be checked