Oracle | DBMS_TRANSFORM

Oracle DBMS_TRANSFORM_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

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 Advanced Queuing Message Transformation

AUTHID DEFINER

Dependencies

AQ$_TRANS_SEQUENCE	DBMS_STANDARD	DBMS_TRANS_LIB
DBMS_AQADM	DBMS_TRANSFORM	DBMS_UTILITY
DBMS_AQINT_LIB	DBMS_TRANSFORM_EXIMP	DUAL
DBMS_ASSERT	DBMS_TRANSFORM_EXIMP_INTERNAL

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by means of an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvttxfm.plg

Subprograms

GET_IDN_LENGTH	I_DROP_TRANSFORMATION	I_MODIFY_TRANS
I_CREATE_TRANS

GET_IDN_LENGTH

Undocumented dbms_transform_internal.get_idn_length RETURN NUMBER;

SELECT dbms_transform_internal.get_idn_length

      FROM dual;

      SELECT dbms_transform_internal.get_idn_length

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object DBMS_TRANSFORM_INTERNAL

I_CREATE_TRANS

Creates a transformation dbms_transform_internal.i_create_trans( schema IN VARCHAR2, name IN VARCHAR2, from_schema IN VARCHAR2, from_type IN VARCHAR2, to_schema IN VARCHAR2, to_type IN VARCHAR2, transformation IN VARCHAR2, is_import IN BOOLEAN);

TBD

I_DROP_TRANSFORMATION

Drops a transformation dbms_transform_internal.i_drop_transformation( trans_owner IN VARCHAR2, trans_name IN VARCHAR2);

TBD

I_MODIFY_TRANS

Modifies a transformation dbms_transform_internal.i_modify_trans( schema IN VARCHAR2, name IN VARCHAR2, attribute_number IN NUMBER, transformation IN VARCHAR2, is_import IN BOOLEAN);

TBD