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

dbms_epg

Procedures/Functions

authorize_dad

procedure authorize_dad (
 dad_name                           in                 varchar2        ,
 user                               in                 varchar2 default
);

create_dad

procedure create_dad (
 dad_name                           in                 varchar2        ,
 path                               in                 varchar2 default
);

deauthorize_dad

procedure deauthorize_dad (
 dad_name                           in                 varchar2        ,
 user                               in                 varchar2 default
);

delete_dad_attribute

procedure delete_dad_attribute (
 dad_name                           in                 varchar2        ,
 attr_name                          in                 varchar2        
);

delete_global_attribute

procedure delete_global_attribute (
 attr_name                          in                 varchar2        
);

drop_dad

procedure drop_dad (
 dad_name                           in                 varchar2        
);

get_all_dad_attributes

procedure get_all_dad_attributes (
 dad_name                           in                 varchar2        ,
 attr_names                         of                    table varchar2,
 attr_values                        of                    table varchar2
);

get_all_dad_mappings

procedure get_all_dad_mappings (
 dad_name                           in                 varchar2        ,
 paths                              of                    table varchar2
);

get_all_global_attributes

procedure get_all_global_attributes (
 attr_names                         of                    table varchar2,
 attr_values                        of                    table varchar2
);

get_dad_attribute

function get_dad_attribute returns varchar2 (
 dad_name                           in                 varchar2        ,
 attr_name                          in                 varchar2        
);

get_dad_list

procedure get_dad_list (
 dad_names                          of                    table varchar2
);

get_global_attribute

function get_global_attribute returns varchar2 (
 attr_name                          in                 varchar2        
);

map_dad

procedure map_dad (
 dad_name                           in                 varchar2        ,
 path                               in                 varchar2        
);

set_dad_attribute

procedure set_dad_attribute (
 dad_name                           in                 varchar2        ,
 attr_name                          in                 varchar2        ,
 attr_value                         in                 varchar2        
);

set_global_attribute

procedure set_global_attribute (
 attr_name                          in                 varchar2        ,
 attr_value                         in                 varchar2        
);

unmap_dad

procedure unmap_dad (
 dad_name                           in                 varchar2        ,
 path                               in                 varchar2 default
);

Links