Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 2 (11.2)

Part Number E25788-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
ARPLS199

118 DBMS_RESCONFIG

The DBMS_RESCONFIG package provides an interface to operate on the resource configuration list, and to retrieve listener information for a resource.

See Also:

Oracle XML DB Developer's Guide for more information about "Resource Configuration".

This chapter contains the following topics:

ARPLS67568

Using DBMS_RESCONFIG

ARPLS67569

Overview

The DBMS_RESCONFIG package contains functions and procedures to manage the resource configuration lists of individual resources and the repository.

ARPLS67570

Summary of DBMS_RESCONFIG Subprograms

This table list the package subprograms in alphabetical order.

ARPLS72107Table 118-1 DBMS_RESCONFIG Package Subprograms

Subprogram Description

ADDREPOSITORYRESCONFIG Procedure

Inserts the resource configuration specified by absolute path at the given position of the repository's configuration list

ADDRESCONFIG Procedure

Inserts the resource configuration specified by the absolute path at the given position in the target resource's configuration list

APPENDRESCONFIG Procedure

Appends the resource configuration specified by rcpath to the target resource's configuration list if it is not already included in the list

DELETEREPOSITORYRESCONFIG Procedure

Removes the configuration at the given position in the repository's configuration list.

DELETERESCONFIG Procedures

Removes the configuration at the given position in the target resource's configuration list. I

GETLISTENERS Function

Returns the list of listeners applicable for a given resource

GETREPOSITORYRESCONFIG Function

Returns the resource configuration at the specified position of the repository's configuration list

GETREPOSITORYRESCONFIGPATHS Function

Returns a list of resource configuration paths defined for the repository

GETRESCONFIG Function

Returns the resource configuration at the specified position of the target resource's configuration list

GETRESCONFIGPATHS Function

Returns a list of resource configuration paths defined in the target resource's configuration list

PATCHREPOSITORYRESCONFIGLIST Procedure

Removes invalid references from the repository resource configuration list, and makes the repository available


ARPLS72108

ADDREPOSITORYRESCONFIG Procedure

This procedure inserts the resource configuration specified by absolute path of the resource configuration at the specified position of the repository's configuration list. It shifts the element currently at that position (if any) and any subsequent elements to the right.

Syntax

DBMS_RESCONFIG.ADDREPOSITORYRESCONFIG(
   rcpath     IN   VARCHAR2, 
   pos        IN   PLS_INTEGER := NULL); 

Parameters

ARPLS72109Table 118-2 ADDREPOSITORYRESCONFIG Function Parameters

Parameter Description

rcpath

Absolute path of the resource configuration to be inserted. An exception is raised if rcpath already exists in the target's configuration list.

pos

Index at which the new configuration is to be inserted. If this parameter is not specified then the new configuration is appended to the end of the list. An exception is raised if the index is out of range (pos < 0 or pos > the size of the target resource's configuration list).


Usage Notes

ARPLS72110

ADDRESCONFIG Procedure

This procedure inserts the resource configuration specified by the absolute path of the resource configuration at the given position in the target resource's configuration list. It shifts the element currently at that position (if any) and any subsequent elements to the right.

Syntax

DBMS_RESCONFIG.ADDRESCONFIG(
   respath    IN   VARCHAR2, 
   rcpath     IN   VARCHAR2, 
   pos        IN   PLS_INTEGER := NULL); 

Parameters

ARPLS72111Table 118-3 ADDRESCONFIG Function Parameters

Parameter Description

respath

Absolute path of the target resource

rcpath

Absolute path of the resource configuration to be inserted. An exception is raised if rcpath already exists in the target's configuration list.

pos

Index at which the new configuration is to be inserted. If this parameter is not specified then the new configuration is appended to the end of the list. An exception is raised if the index is out of range (pos < 0 or pos > the size of the target resource's configuration list).


Usage Notes

ARPLS72112

APPENDRESCONFIG Procedure

This procedure appends the resource configuration specified by rcpath to the target resource's configuration list if it is not already included in the list.

Syntax

DBMS_RESCONFIG.ADDRESCONFIG(
   respath       IN   VARCHAR2, 
   rcpath        IN   VARCHAR2, 
   appendOption  IN   PLS_INTEGER); 

Parameters

ARPLS72113Table 118-4 ADDRESCONFIG Function Parameters

Parameter Description

respath

Absolute path of the target resource

rcpath

Absolute path of the resource configuration to be appended at the end of the target's configuration list. If rcpath already exists in the list then nothing is appended.

appendOption

Either APPEND_RESOURCE or APPEND_RECURSIVE. If APPEND_RESOURCE is specified then only the target resource is affected. If APPEND_RECURSIVE is specified then the target resource and all its descendents will be affected.


Usage Notes

ARPLS72114

DELETEREPOSITORYRESCONFIG Procedure

This procedure removes the configuration at the given position in the repository's configuration list. It shifts any subsequent elements to the left.

Syntax

DBMS_RESCONFIG.DELETEREPOSITORYRESCONFIG(
   pos           IN   PLS_INTEGER);

Parameters

ARPLS72115Table 118-5 DELETEREPOSITORYRESCONFIG Function Parameters

Parameter Description

pos

The index of the configuration to be removed. An exception is raised if the index is out of range (pos < 0 or pos >= the size of the target resource's configuration list).


Usage Notes

ARPLS72116

DELETERESCONFIG Procedures

This procedure removes the configuration at the given position in the target resource's configuration list. It shifts any subsequent elements to the left. Users can use the overloaded for recursive deletion.

Syntax

DBMS_RESCONFIG.DELETERESCONFIG(
   respath       IN   VARCHAR2, 
   pos           IN   PLS_INTEGER);
DBMS_RESCONFIG.DELETERESCONFIG(
   respath        IN  VARCHAR2,
   rcpath         IN  VARCHAR2, 
   deleteOption   IN  PLS_INTEGER);

Parameters

ARPLS72117Table 118-6 DELETERESCONFIG Procedure Parameters

Parameter Description

respath

Absolute path of the target resource

pos

The index of the configuration to be removed. An exception is raised if the index is out of range (pos < 0 or pos >= the size of the target resource's configuration list).

rcpath

Absolute path of the resource configuration to be deleted if found in list.

deleteOption

Either DELETE_RESOURCE or DELETE_RECURSIVE. If DELETE_RESOURCE is specified then only the configuration list of the target resource is affected. If DELETE_RECURSIVE is specified then the configuration list of the target resource and all its descendents will be affected.


Usage Notes

Users must have WRITE-CONFIG privilege on the target resource to execute this.

ARPLS72118

GETLISTENERS Function

This function returns the list of listeners applicable for a given resource.

The value returned by this function is an XML document containing the <event-listeners> element of the XDBResconfig.xsd schema. It contains all the listeners applicable to the target resource, including repository-level listeners. From the returned XML document users can use the EXTRACT operator to retrieve the listeners defined for a specific event.

Syntax

DBMS_RESCONFIG.GETLISTENERS(
   path    IN   VARCHAR2)
 RETURN XMLTYPE; 

Parameters

ARPLS72119Table 118-7 GETLISTENERS Function Parameters

Parameter Description

path

Absolute path of the target resource


Usage Notes

Users must have the required access privilege on all resource configurations referenced by the repository and the target resource; otherwise, an error is returned.

ARPLS72120

GETREPOSITORYRESCONFIG Function

This function returns the resource configuration at the specified position of the repository's configuration list.

Syntax

DBMS_RESCONFIG.GETREPOSITORYRESCONFIG(
   pos    IN   PLS_INTEGER)
 RETURN XMLTYPE; 

Parameters

ARPLS72121Table 118-8 GETREPOSITORYRESCONFIG Function Parameters

Parameter Description

pos

Index of element to return. An exception is raised if the index is out of range (pos < 0 or pos >= the size of the repository's configuration list).


Usage Notes

Users must have the required read privilege on the requested resource configuration; otherwise, an error is returned.

ARPLS72122

GETREPOSITORYRESCONFIGPATHS Function

This function returns a list of resource configuration paths defined for the repository.

Syntax

DBMS_RESCONFIG.GETREPOSITORYRESCONFIGPATHS
 RETURN XDB$STRING_LIST_T; 

Usage Notes

Users must be able to access all the referenced resource configurations; otherwise, an error is returned.

ARPLS72123

GETRESCONFIG Function

This function returns the resource configuration at the specified position of the target resource's configuration list.

Syntax

DBMS_RESCONFIG.GETRESCONFIG(
   respath IN VARCHAR2,  
   pos IN PLS_INTEGER)
 RETURN XMLTYPE; 

Parameters

ARPLS72124Table 118-9 GETRESCONFIG Function Parameters

Parameter Description

respath

Absolute path of the target resource

pos

Index of element to return. An exception is raised if the index is out of range (pos < 0 or pos >= the size of the target resource's configuration list).


Usage Notes

Users must have the required read privilege on the requested resource configuration; otherwise, an error is returned.

ARPLS72125

GETRESCONFIGPATHS Function

This function returns a list of resource configuration paths defined in the target resource's configuration list.

Syntax

DBMS_RESCONFIG.GETRESCONFIGPATHS(
   respath IN VARCHAR2)  
 RETURN XDB$STRING_LIST_T; 

Parameters

ARPLS72126Table 118-10 GETRESCONFIGPATHS Function Parameters

Parameter Description

respath

Absolute path of the target resource


Usage Notes

Users must be able to access all the referenced resource configurations; otherwise, an error is returned.

ARPLS72127

PATCHREPOSITORYRESCONFIGLIST Procedure

Under normal circumstances, deletion of a resource configuration resource cannot be performed if it is part of the repository resource configuration list. If, for some reason, the deletion of a resource configuration resource that is part of the repository resource configuration list succeeds, then any repository operation results in a 'dangling reference' error. This procedure removes invalid references from the repository resource configuration list, and makes the repository available. This procedure must be run as SYS.

Syntax

DBMS_RESCONFIG.PATCHREPOSITORYRESCONFIGLIST;
Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

  • Using DBMS_RESCONFIG
  • Summary of DBMS_RESCONFIG Subprograms
    • ADDREPOSITORYRESCONFIG Procedure
    • ADDRESCONFIG Procedure
    • APPENDRESCONFIG Procedure
    • DELETEREPOSITORYRESCONFIG Procedure
    • DELETERESCONFIG Procedures
    • GETLISTENERS Function
    • GETREPOSITORYRESCONFIG Function
    • GETREPOSITORYRESCONFIGPATHS Function
    • GETRESCONFIG Function
    • GETRESCONFIGPATHS Function
    • PATCHREPOSITORYRESCONFIGLIST Procedure

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF