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

dbms_xdb

Procedures/Functions

aclcheckprivileges

function aclcheckprivileges returns binary_integer (
 acl_path                           in                 varchar2        ,
 owner                              in                 varchar2        ,
 privs                              in                  xmltype        
);

cfg_get

function cfg_get returns xmltype (
);
cfg_get can be used to get the session's configuration information:
set long 10000000
select dbms_xdb.cfg_get() from dual;

cfg_refresh

procedure cfg_refresh (
);

cfg_update

procedure cfg_update (
 xdbconfig                          in                  xmltype        
);

changeprivileges

function changeprivileges returns binary_integer (
 res_path                           in                 varchar2        ,
 ace                                in                  xmltype        
);

checkprivileges

function checkprivileges returns binary_integer (
 res_path                           in                 varchar2        ,
 privs                              in                  xmltype        
);

cleansgaforupgrade

procedure cleansgaforupgrade (
);

createfolder

function createfolder returns boolean (
 abspath                            in                 varchar2        
);

createoidpath

function createoidpath returns varchar2 (
 oid                                in                      raw        
);

createresource

function createresource returns boolean (
 abspath                            in                 varchar2        ,
 data                               in                 varchar2        
);
function createresource returns boolean (
 abspath                            in                 varchar2        ,
 data                               in                  xmltype        
);
function createresource returns boolean (
 abspath                            in                 varchar2        ,
 data                               of                      ref xmltype,
 sticky                             in                  boolean default
);
function createresource returns boolean (
 abspath                            in                 varchar2        ,
 data                               in                     clob        
);
function createresource returns boolean (
 abspath                            in                 varchar2        ,
 data                             file                   binary     lob,
 csid                               in                   number default
);
function createresource returns boolean (
 abspath                            in                 varchar2        ,
 data                               in                     blob        ,
 csid                               in                   number default
);

deleteresource

procedure deleteresource (
 abspath                            in                 varchar2        ,
 delete_option                      in           binary_integer default
);

existsresource

function existsresource returns boolean (
 abspath                            in                 varchar2        
);

getacldocument

function getacldocument returns xmltype (
 abspath                            in                 varchar2        
);

getlocktoken

procedure getlocktoken (
 abspath                            in                 varchar2        ,
 locktoken                         out                 varchar2        
);

getprivileges

function getprivileges returns xmltype (
 res_path                           in                 varchar2        
);

getresoid

function getresoid returns raw (
 abspath                            in                 varchar2        
);

getxdb_tablespace

function getxdb_tablespace returns varchar2 (
);
procedure link (
 srcpath                            in                 varchar2        ,
 linkfolder                         in                 varchar2        ,
 linkname                           in                 varchar2        
);

lockresource

function lockresource returns boolean (
 abspath                            in                 varchar2        ,
 depthzero                          in                  boolean        ,
 shared                             in                  boolean        
);

migrateallxmlfrom9201

procedure migrateallxmlfrom9201 (
);

migratecolumnfrom9201

procedure migratecolumnfrom9201 (
 owner                              in                 varchar2        ,
 table_name                         in                 varchar2        ,
 column_name                        in                 varchar2        
);

migratetablefrom9201

procedure migratetablefrom9201 (
 owner                              in                 varchar2        ,
 table_name                         in                 varchar2        
);

movexdb_tablespace

procedure movexdb_tablespace (
 new_tablespace                     in                 varchar2        
);

rebuildhierarchicalindex

procedure rebuildhierarchicalindex (
);

renameresource

procedure renameresource (
 srcpath                            in                 varchar2        ,
 destfolder                         in                 varchar2        ,
 newname                            in                 varchar2        
);

setacl

procedure setacl (
 res_path                           in                 varchar2        ,
 acl_path                           in                 varchar2        
);

unlockresource

function unlockresource returns boolean (
 abspath                            in                 varchar2        ,
 deltoken                           in                 varchar2        
);