Search Results propval_complvl_none




Overview

DBMS_DBFS_HS is an Oracle-supplied PL/SQL package owned by SYS and declared with AUTHID CURRENT_USER. It functions as a hierarchical storage service provider layered beneath DBMS_DBFS_CONTENT, enabling Oracle Database content to be written to and retrieved from secondary storage tiers — tape libraries or the Amazon S3 web service — while remaining addressable through standard database APIs. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is relevant primarily as part of the underlying database platform rather than as an Applications-owned API. It supports Information Lifecycle Management strategies in which infrequently accessed content is relocated to lower-cost storage without removing it from the database's control. The package defines two supported store types, STORETYPE_TAPE ('HS_TAPE') and STORETYPE_AMAZONS3 ('HS_S3'), which are the only valid values for the store_type parameter of its createStore method. It also defines a fixed set of property name constants — including PROPNAME_SBTLIBRARY, PROPNAME_MEDIAPOOL, PROPNAME_OPTTARBALLSIZE, PROPNAME_READCHUNKSIZE, PROPNAME_WRITECHUNKSIZE, PROPNAME_S3HOST, PROPNAME_HTTPPROXY, PROPNAME_WALLET, PROPNAME_BUCKET, PROPNAME_ALIAS, PROPNAME_LICENSEID, PROPNAME_CACHESIZE, PROPNAME_LOBCACHE_QUOTA, and PROPNAME_COMPRESSLEVEL — together with compression-level values such as PROPVAL_COMPLVL_NONE and PROPVAL_COMPLVL_LOW. Because the package operates on database filesystem hierarchies, its behavior is independent of EBS application code, though EBS deployments that archive attachments or outbound documents to tape or S3 may rely on it indirectly.

The search term recorded against this object — "amazon corretto 21.0.11.cve vulnerabilities10.1" — does not correspond to any functionality of DBMS_DBFS_HS. Amazon Corretto is a Java runtime distribution, and CVE references pertain to Java security advisories. This package is PL/SQL executing inside the Oracle Database kernel; it has no dependency on the JVM version used by EBS application-tier services such as Oracle Forms, Oracle HTTP Server, or concurrent manager Java components. Consequently, this object neither introduces nor mitigates Corretto-related vulnerabilities.

Key Procedures and Functions

ETRM documents 43 procedures and functions for this package. The principal documented entries include:

  • GETFEATURES — returns the capabilities supported by a configured hierarchical store.
  • GETSTOREID — resolves the identifier associated with a store.
  • GETVERSION — reports the package version.
  • SPACEUSAGE — reports storage consumption for the store or its contents.
  • CREATEFILE, CREATEDIRECTORY, CREATELINK, CREATEREFERENCE — create file, directory, link, and reference nodes within the hierarchical store.
  • DELETEFILE, DELETEDIRECTORY, DELETECONTENT — remove individual files, directories, or content payloads.
  • RESTOREPATH, RESTOREALL, PURGEPATH, PURGEALL — move content between storage tiers, restoring archived paths on demand or purging them when no longer required.
  • GETPATH, GETPATHNOWAIT, PUTPATH, RENAMEPATH, SETPATH — retrieve, write, rename, and set attributes on stored paths.

These routines collectively implement the provider contract expected by DBMS_DBFS_CONTENT. Parameter lists are intentionally omitted here; consult the Oracle Database PL/SQL Packages and Types Reference for exact signatures.

Tables Accessed

The ETRM metadata for this object lists no tables referenced through APPS synonyms. This is consistent with the package's design: DBMS_DBFS_HS is a service-provider layer that manipulates the database filesystem repository maintained by DBMS_DBFS_CONTENT, rather than reading or writing EBS application tables directly. Store definitions, properties, and content metadata are persisted in the underlying DBFS dictionary managed by the database itself.

Usage Notes

DBMS_DBFS_HS is generally invoked by DBAs or by infrastructure-level PL/SQL, not by EBS forms or concurrent programs. Typical usage involves configuring a store with createStore using STORETYPE_TAPE or STORETYPE_AMAZONS3, applying property values through setStoreProperty, and then using the path-oriented routines to place, retrieve, restore, or purge content. The package is referenced by three other packages according to the ETRM metadata, indicating that higher-level DBFS components depend on it. In an EBS 12.1.1 or 12.2.2 context, custom code that implements attachment or document archiving to tape or S3 may call it directly, but such integrations should be treated as customizations outside the supported Applications schema. Where the goal is remediation of Java-related CVEs, attention should instead be directed at the application-tier JRE configuration and Oracle's published EBS security guidance.