Oracle | DBMS_JSON_DUALITY

Oracle DBMS_JSON_DUALITY_INT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal utilities supporting the interface used by the REST implementation for multi-operation serializable transactions.

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_JSON_DUALITY_LIB	DBMS_STANDARD
DBMS_JSON_DUALITY

Documented No

First Available 23ai

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtdv.plb

Subprograms

GENERATE_SCHEMA_INTERNAL	IMPORT_INTERNAL
GET_JSON_COL_NAME	INFER_AND_GENERATE_SCHEMA_INTERNAL
GET_JSON_KEY_NAME	INFER_SCHEMA_INTERNAL
GET_SCHEMA_NAME

GENERATE_SCHEMA_INTERNAL (new 23ai)

Undocumented dbms_json_duality_int.generateSchemaInternal( er_schema IN JSON, schema IN OUT CLOB);

TBD

GET_JSON_COL_NAME (new 23ai)

Undocumented dbms_json_duality_int.get_json_col_name( table_owner IN VARCHAR2, table_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_JSON_KEY_NAME (new 23ai)

Undocumented dbms_json_duality_int.get_json_key_name( view_owner IN VARCHAR2, view_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_SCHEMA_NAME (new 23ai)

Undocumented dbms_json_duality_int.get_schema_name(owner IN VARCHAR2) RETURN VARCHAR2;

conn / as sysdba

      

      SELECT dbms_json_duality_int.get_schema_name('C##SCOTT');

             *

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

IMPORT_INTERNAL (new 23ai)

Undocumented dbms_json_duality_int.import_internal( table_owner_name IN VARCHAR2, table_name IN VARCHAR2, view_owner_name IN VARCHAR2, view_name IN VARCHAR2, err_log_owner_name IN VARCHAR2, err_log_name IN VARCHAR2, reject_limit IN NUMBER);

TBD

INFER_AND_GENERATE_SCHEMA_INTERNAL (new 23ai)

Undocumented dbms_json_duality_int.infer_and_generate_schema_internal( config IN JSON, schema IN OUT CLOB);

TBD

INFER_SCHEMA_INTERNAL (new 23ai)

Undocumented dbms_json_duality_int.infer_schema_internal( config IN JSON, er_schema IN OUT JSON);

TBD