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
ARPLS72775

244 DBFS Content Interface Types

This chapter describes public types defined to support the DBMS_DBFS_CONTENT interface.

This chapter contains the following topics:

ARPLS72776

Using Content Types

ARPLS72777

Overview

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.

ARPLS72778

Security Model

The user can access the content operational and administrative interfaces (packages, types, tables, and so on) by way of the DBFS_ROLE. This role can be granted to users as needed.

ARPLS72779

Data Structures

Types that support the DBMS_DBFS_CONTENT interface include both Object and Table types.

Object Types

Table Types

ARPLS72780

DBMS_DBFS_CONTENT_CONTEXT_T Object Type

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.

Syntax

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);

Fields

ARPLS72781Table 244-1 DBMS_DBFS_CONTENT_CONTEXT_T Fields

Field Description

principal

File system user

acl

Access control list

owner

Path item owner

asof

Timestamp

read_only

Nonzero if the path item is read-only


ARPLS72782

DBMS_DBFS_CONTENT_LIST_ITEM_T Object Type

This type describes a type to assist in listing the contents of a directory.

Syntax

CREATE OR REPLACE TYPE dbms_dbfs_content_list_item_t
    AUTHID DEFINER
AS OBJECT (
    path          VARCHAR2(1024),
    item_name     VARCHAR2(256),
    item_type     INTEGER);

Fields

ARPLS72783Table 244-2 DBMS_DBFS_CONTENT_LIST_ITEM_T Fields

Field Description

path

Path to the path item

item_name

Name of the path item

item_type

Type of path item. (See DBMS_DBFS_CONTENT Constants - Path Name Types


ARPLS72784

DBMS_DBFS_CONTENT_PROPERTY_T Object Type

This type describes a single (name, value, 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 DBMS_DBFS_CONTENT interface.

Syntax

CREATE OR REPLACE TYPE dbms_dbfs_content_property_t
    AUTHID DEFINER
AS OBJECT (
    propname     VARCHAR2(32),
    propvalue    VARCHAR2(1024),
    typecode     INTEGER);

Fields

ARPLS72785Table 244-3 DBMS_DBFS_CONTENT_PROPERTY_T Fields

Field Description

prop_name

Name of property

prop_value

Value of property

typecode

Property type (See Constants in DBMS_TYPES)


ARPLS72786

DBMS_DBFS_CONTENT_LIST_ITEMS_T Table Type

This type is a variable-sized array of DBMS_DBFS_CONTENT_LIST_ITEM_T Object Type. It is used by both the client-facing interfaces and by store providers for the DBMS_DBFS_CONTENT interface.

Syntax

CREATE OR REPLACE TYPE dbms_dbfs_content_list_items_t AS
    TABLE OF dbms_dbfs_content_list_item_t;
ARPLS72787

DBMS_DBFS_CONTENT_PROPERTIES_T Table Type

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 DBMS_DBFS_CONTENT interface.

Syntax

CREATE OR REPLACE TYPE dbms_dbfs_content_properties_t AS
    TABLE OF dbms_dbfs_content_property_t;
ARPLS72788

DBMS_DBFS_CONTENT_RAW_T Table Type

This type is an array of RAW. It is to enable RAW data transport for batch interfaces in the DBMS_DBFS_CONTENT interface.

Syntax

CREATE OR REPLACE TYPE dbms_dbfs_content_raw_t AS
    TABLE OF RAW(32767);
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 Content Types
  • Data Structures
    • DBMS_DBFS_CONTENT_CONTEXT_T Object Type
    • DBMS_DBFS_CONTENT_LIST_ITEM_T Object Type
    • DBMS_DBFS_CONTENT_PROPERTY_T Object Type
    • DBMS_DBFS_CONTENT_LIST_ITEMS_T Table Type
    • DBMS_DBFS_CONTENT_PROPERTIES_T Table Type
    • DBMS_DBFS_CONTENT_RAW_T Table Type

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF