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 will be available on generic Linux platforms in January and soon on AIX and Windows

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