Search Results dbms_dbfs_content




Overview
Explore in AI Chat

Overview

SYS.DBMS_DBFS_CONTENT is an Oracle-supplied PL/SQL package that implements the Database File System (DBFS) content-store interface. In Oracle E-Business Suite releases 12.1.1 and 12.2.2, this package provides the low-level API through which DBFS stores, mounts, paths, and content items are defined and manipulated. DBFS itself presents a POSIX-like hierarchical file system whose files are persisted as SecureFiles LOBs inside database tables, and it is this package that mediates all interaction between the file-system layer and the underlying content store. The package is owned by SYS, is reported as VALID in ETRM, and is classified under the API classification OTHER. Although most EBS application developers will never call it directly, it is a foundational dependency for the DBFS infrastructure used by EBS for large-file storage, file attachments held outside the standard FND_LOBS table, and integration with external file systems via the FUSE and Hierarchical Storage (HS) adapters.

Key Procedures and Functions

ETRM documents 98 procedures and functions in this package. The following are representative of the documented set:

  • Property conversion helpers — PROPERTIEST2H, PROPERTIESH2T, PROPANY, PROPNUMBER, PROPVARCHAR2, PROPTIMESTAMP, and PROPRAW. These convert between the internal tabular (T) and hierarchical (H) representations of DBFS content properties and extract typed property values from a property collection.
  • Store lifecycle — REGISTERSTORE, UNREGISTERSTORE, MOUNTSTORE, REMOUNTSTORE, REMOUNTALL, UNMOUNTSTORE, and UNMOUNTALL. These create and destroy store definitions and control whether a store is visible through the DBFS mount points.
  • Store enumeration and lookup — LISTSTORES, LISTMOUNTS, GETSTOREBYPATH, GETSTOREBYNAME, GETSTOREBYMOUNT, and GETFEATURESBYPATH. These return registered stores, active mounts, store metadata resolved by path, name, or mount point, and the feature set exposed at a given path.

The package depends on supporting types DBMS_DBFS_CONTENT_CONTEXT_T, DBMS_DBFS_CONTENT_LIST_ITEMS_T, DBMS_DBFS_CONTENT_PROPERTIES_T, and DBMS_DBFS_CONTENT_RAW_T, and on the STANDARD package.

Tables Accessed

ETRM does not list any base tables accessed by this package through APPS synonyms. DBFS content is instead stored in the SYS.DBFS_CONTENT and SYS.DBFS_CONTENT_PROPERTIES tables, which are themselves dependent on this package and are owned by SYS rather than exposed to the APPS schema. Store and mount definitions are likewise maintained in DBFS-owned dictionary objects. Consequently, DBMS_DBFS_CONTENT should be regarded as operating on DBFS metadata tables under the SYS schema, not on EBS application tables.

Usage Notes

In EBS 12.1.1 and 12.2.2, DBMS_DBFS_CONTENT is normally invoked indirectly. It is referenced by nine other packages, including the public synonym DBMS_DBFS_CONTENT, DBMS_DBFS_CONTENT_ADMIN, DBMS_DBFS_SFS, DBMS_DBFS_SFS_ADMIN, DBMS_DBFS_HS, DBMS_ARCH_PROVIDER_INTL, DBMS_FUSE, and DBMS_LOB_AM_PRIVATE. Administrators typically interact with the higher-level SecureFile Store (SFS) and Hierarchical Storage (HS) packages, which in turn call this content layer. Direct invocation from EBS Forms, concurrent programs, or custom code is uncommon and is generally limited to DBFS provisioning, store registration, and diagnostic scripts. Because the package resides in SYS and is not granted broadly to the APPS schema, any use from custom EBS code requires careful privilege review and should be restricted to explicitly authorized DBA scripts.