This chapter describes public types defined to support the DBMS_DBFS_CONTENT interface.
This chapter contains the following topics:
The type definitions described in this chapter support the DBMS_DBFS_CONTENT interface in implementing metadata tables, packages, views, dependent application-side entities, and service-provider entities.
Types that support the DBMS_DBFS_CONTENT interface include both Object and Table types.
This type describes the execution context for the providers. It provides the user performing the operation with the Access Control List, the owner of the item(s), a timestamp for doing
asof queries, and whether or not the item(s) are
read_only. This type can be used both as input, in the case of path item creation functions, and output, in the case of path item query, or both.
CREATE OR REPLACE TYPE dbms_dbfs_content_context_t AUTHID DEFINER AS OBJECT ( principal VARCHAR2(32), acl VARCHAR2(1024), owner VARCHAR2(32), asof TIMESTAMP, read_only INTEGER);
This type describes a type to assist in listing the contents of a directory.
CREATE OR REPLACE TYPE dbms_dbfs_content_list_item_t AUTHID DEFINER AS OBJECT ( path VARCHAR2(1024), item_name VARCHAR2(256), item_type INTEGER);
Path to the path item
Name of the path item
Type of path item. (See DBMS_DBFS_CONTENT Constants - Path Name Types
This type describes a single (
typecode) property tuple. All properties (standard, optional, and user-defined) are described using such tuples.
The type is used by both the client-facing interfaces and by store providers for the
CREATE OR REPLACE TYPE dbms_dbfs_content_property_t AUTHID DEFINER AS OBJECT ( propname VARCHAR2(32), propvalue VARCHAR2(1024), typecode INTEGER);
This type is a variable-sized array of property tuples of DBMS_DBFS_CONTENT_PROPERTY_T Object Type. It is used by both the client-facing interfaces and by store providers for the
This type is an array of
RAW. It is to enable
RAW data transport for batch interfaces in the DBMS_DBFS_CONTENT interface.