René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

dbms_registry

dbms_registry is not documented by Oracle Coorporation because it's used by Oracle components (such as xmldb) to register themselves.
However, the content of the registry is exposed through the registry related static views..

Procedures/Functions

check_server_instance

procedure check_server_instance (
);

comp_name

function comp_name returns varchar2 (
 comp_id                            in                 varchar2        
);

dbdwg_script

function dbdwg_script returns varchar2 (
 comp_id                            in                 varchar2        
);

dbupg_script

function dbupg_script returns varchar2 (
 comp_id                            in                 varchar2        
);

downgraded

procedure downgraded (
 comp_id                            in                 varchar2        ,
 old_version                        in                 varchar2        
);

downgrading

procedure downgrading (
 comp_id                            in                 varchar2        ,
 old_name                           in                 varchar2 default,
 old_proc                           in                 varchar2 default,
 old_schema                         in                 varchar2 default,
 old_parent                         in                 varchar2 default
);

gather_stats

procedure gather_stats (
 comp_id                            in                 varchar2        
);

invalid

procedure invalid (
 comp_id                            in                 varchar2        
);

is_loaded

function is_loaded returns number (
 comp_id                            in                 varchar2        ,
 version                            in                 varchar2 default
);

is_startup_required

function is_startup_required returns number (
 comp_id                            in                 varchar2        
);

is_valid

function is_valid returns number (
 comp_id                            in                 varchar2        ,
 version                            in                 varchar2 default
);

loaded

procedure loaded (
 comp_id                            in                 varchar2        ,
 comp_version                       in                 varchar2 default,
 comp_banner                        in                 varchar2 default
);

loading

procedure loading (
 comp_id                            in                 varchar2        ,
 comp_name                          in                 varchar2        ,
 comp_proc                          in                 varchar2 default,
 comp_schema                        in                 varchar2 default,
 comp_parent                        in                 varchar2 default
);

nothing_script

function nothing_script returns varchar2 (
);

patch_script

function patch_script returns varchar2 (
 comp_id                            in                 varchar2        
);

relod_script

function relod_script returns varchar2 (
 comp_id                            in                 varchar2        
);

removed

procedure removed (
 comp_id                            in                 varchar2        
);

removing

procedure removing (
 comp_id                            in                 varchar2        
);

reset_version

procedure reset_version (
 comp_id                            in                 varchar2        
);

schema

function schema returns varchar2 (
 comp_id                            in                 varchar2        
);

script

function script returns varchar2 (
 comp_id                            in                 varchar2        ,
 script_name                        in                 varchar2        
);

script_path

function script_path returns varchar2 (
 comp_id                            in                 varchar2        
);

script_prefix

function script_prefix returns varchar2 (
 comp_id                            in                 varchar2        
);

session_namespace

function session_namespace returns varchar2 (
);

set_comp_namespace

procedure set_comp_namespace (
 comp_id                            in                 varchar2        ,
 namespace                          in                 varchar2        
);

set_session_namespace

procedure set_session_namespace (
 namespace                          in                 varchar2        
);

startup_complete

procedure startup_complete (
 comp_id                            in                 varchar2        
);

startup_required

procedure startup_required (
 comp_id                            in                 varchar2        
);

status

function status returns varchar2 (
 comp_id                            in                 varchar2        
);

subcomponents

function subcomponents returns table of varchar2(30) (
 comp_id                            in                 varchar2        ,
 comp_option                        in                   number default
);

time_stamp

function time_stamp returns varchar2 (
 comp_id                            in                 varchar2        
);

upgraded

procedure upgraded (
 comp_id                            in                 varchar2        ,
 new_version                        in                 varchar2 default,
 new_banner                         in                 varchar2 default
);

upgrading

procedure upgrading (
 comp_id                            in                 varchar2        ,
 new_name                           in                 varchar2 default,
 new_proc                           in                 varchar2 default,
 new_schema                         in                 varchar2 default,
 new_parent                         in                 varchar2 default
);

valid

procedure valid (
 comp_id                            in                 varchar2        
);

validate_components

procedure validate_components (
);

version

function version returns varchar2 (
 comp_id                            in                 varchar2        
);