ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Implements lower-level functions for defining heterogeneous object types
AUTHID
CURRENT_USER
Constants
Name
Data Type
Value
TOP_LEVEL_TYPE
NUMBER
0
DATATYPE_MIN
NUMBER
1
DATATYPE_BOOLEAN
NUMBER
1
DATATYPE_NUMERIC
NUMBER
2
DATATYPE_TEXT
NUMBER
3
DATATYPE_CUSTOM_FILTER
NUMBER
3
DATATYPE_TEXT_EXPR
NUMBER
4
DATATYPE_OBJNUM
NUMBER
5
DATATYPE_VAT_OBJNUM
NUMBER
6
DATATYPE_MAX
NUMBER
6
TYPE_HETEROGENEOUS
BOOLEAN
TRUE
TYPE_HOMOGENEOUS
BOOLEAN
FALSE
Dependencies
DBMS_METADATA
DBMS_METADATA_UTIL
DBMS_SYS_ERROR
DBMS_METADATA_DPBUILD
DBMS_OUTPUT
DBMS_UTILITY
DBMS_METADATA_INT
DBMS_STANDARD
PLITBLM
Documented
No
Exceptions
Error Code
Reason
31600
invalid_argval: Invalid argument
31601
invalid_operation: Invalid operation
First Available
9.0
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Begins creation of a filter for a type. The filter will not be inserted into the dictionary until CLOSE is called. If the owning type (designated by 'handle') is not heterogeneous, then the filter must already be defined in sys.metafilter$.
dbms_metadata_build.create_filter(
handle IN NUMBER,
name IN VARCHAR2,
datatype IN NUMBER)
RETURN NUMBER;