ut_metadata
UT_METADATA
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 | |
| 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 | |
| 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 |