Search Results dbms_xdbresource




Overview
Explore in AI Chat

Overview

XDB.DBMS_XDBRESOURCE is an Oracle XML DB repository package supplied by the XDB schema and shipped as a standard component of the Oracle Database used beneath Oracle E-Business Suite 12.1.1 and 12.2.2. It provides a PL/SQL programmatic interface to the resources stored in the XML DB repository — the hierarchical, path-addressed store that holds XML documents, folders, and other binary or textual resources. Within the EBS technology stack, the package is not an application-layer API; it exists to support the database's own repository infrastructure and the higher-level XML DB packages (DBMS_XDB, DBMS_XDB_REPOS, DBMS_XEVENT) that depend upon it. The ETRM record lists the object as VALID with owner XDB and classifies it as OTHER, reflecting its role as an internal utility package rather than a concurrent-program or forms-driven API.

Key Procedures and Functions

The ETRM metadata documents 58 procedures and functions on the package. The publicly documented members fall into two functional groups:

  • Resource metadata getters and setters — GETACL and GETACLDOCFROMRES retrieve the access control list and its XML document form for a resource; GETAUTHOR, SETAUTHOR, GETCREATOR, GETLASTMODIFIER, GETMODIFICATIONDATE, GETCREATIONDATE, GETOWNER, GETDISPLAYNAME, GETCOMMENT, GETLANGUAGE, GETCHARACTERSET, SETCHARACTERSET, GETCONTENTTYPE, GETVERSIONID, and GETREFCOUNT expose and, where paired, modify individual properties of a repository resource.
  • Resource lifecycle utilities — ISNULL tests a resource reference for nullity, and FREERESOURCE releases the in-memory handle associated with a resource once processing completes, preventing resource leakage in the session.

The breadth of the getter set indicates that the package is the metadata access layer for resources, while content itself is handled through XMLTYPE operations. No parameter lists are asserted here; callers should consult the package specification for exact signatures.

Tables Accessed

ETRM records the package as referencing DBMS_LOB and XMLTYPE through APPS synonyms. These are not application tables but Oracle-supplied types and packages: DBMS_LOB supplies the LOB manipulation primitives used to read and write resource content, and XMLTYPE provides the XML document abstraction that represents XML-format repository resources. The package also depends on the SYS schema, the STANDARD package, and XDB.DBMS_XMLDOM within the database. Repository resources themselves are persisted in the XML DB internal tables under the XDB schema rather than in EBS application tables; consequently, no EBS transactional tables are touched by this package.

Usage Notes

XDB.DBMS_XDBRESOURCE is referenced by the PUBLIC synonym DBMS_XDBRESOURCE and by XDB.DBMS_XDB, DBMS_XDB_REPOS, DBMS_XEVENT, and the package itself. In an EBS 12.1.1 or 12.2.2 environment, it is invoked indirectly — during repository configuration, XML DB event processing, or operations that manage repository resources — rather than from Oracle Forms or concurrent programs. Custom code that manipulates XML DB repository content may call the documented getters and setters directly, but such code runs against the database repository model and is independent of EBS application logic. Because the package is owned by XDB and classified as OTHER, it should be treated as Oracle-managed database infrastructure: it should not be modified, and any invocation from custom EBS code should be limited to the documented public interface.