Oracle | DBMS_JSON

Oracle DBMS_JSON_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 JSON support utilities

AUTHID CURRENT_USER

Dependencies

DBMS_JSON

DBMS_JSON_LIB

Documented No

First Available 12.2

Security Model Owned by XDB with no privileges granted

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

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

Subprograms

ADDVC	CREATEVIEWONPATH	GETMVISPECS
BLOB2JSON	DROPVC	PJCOLINM
CHECKPRIVILEGE	GETDATAGUIDE	RENAME
CHECKPRIVILEGE2	GETMVISPEC

ADDVC

Add a virtual column dbms_json_int.addVC( owner IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2, indexname IN VARCHAR2, frequency IN NUMBER, hidden IN BOOLEAN);

CREATE TABLE j_purchase_order(

      doc_id      RAW (16) NOT NULL,

      date_loaded TIMESTAMP(6) WITH TIME ZONE,

      po_document CLOB);

      

      SELECT DISTINCT defer, condition

      FROM cdef$;

      

      ALTER TABLE j_purchase_order

      ADD CONSTRAINT ensure_json

      CHECK (po_document IS JSON);

      

      exec xdb.dbms_json_int.addVC(USER, 'J_PURCHASE_ORDER', 'po_document', NULL, NULL, TRUE);

BLOB2JSON

See DBMS_JSON.

Protected by an ACCESSIBLE BY clause dbms_json_int.blob2json( owner IN VARCHAR2, tablename IN VARCHAR2, columnname IN VARCHAR2, throwerror IN BOOLEAN);

See DBMS_JSON.BLOB_TO_JSON

CHECKPRIVILEGE

Undocumented dbms_json_int.checkPrivilege( uname IN VARCHAR2, owner IN VARCHAR2, tablename IN VARCHAR2);

TBD

CHECKPRIVILEGE2 (new 23ai)

Undocumented dbms_json_int.checkprivilege2( uname IN VARCHAR2, owner IN VARCHAR2, indexname IN VARCHAR2);

TBD

CREATEVIEWONPATH

Undocumented dbms_json_int.createViewOnPath( owner IN VARCHAR2, viewname IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2, path IN VARCHAR2, indexname IN VARCHAR2, frequency IN NUMBER, resourcepath IN VARCHAR2, materialize IN BOOLEAN);

TBD

DROPVC

Drop a virtual column dbms_json_int.dropVC( owner IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2, indexname IN VARCHAR2);

TBD

GETDATAGUIDE

Undocumented dbms_json_int.getDataGuide( owner IN VARCHAR2, indexname IN VARCHAR2, format IN NUMBER, dataguide IN OUT CLOB);

TBD

GETMVISPEC (new 23ai)

Undocumented dbms_json_int.getmvispec( owner IN VARCHAR2, indexname IN VARCHAR2, mvispec IN OUT CLOB);

TBD

GETMVISPECS (new 23ai)

Undocumented dbms_json_int.getmvispecs( owner IN VARCHAR2, tablename IN VARCHAR2, mvispec IN OUT CLOB);

TBD

PJCOLINM

Undocumented dbms_json_int.pjcolinm( owner IN VARCHAR2, tabname IN VARCHAR2, jcolname IN VARCHAR2, format IN VARCHAR2);

TBD

RENAME

Undocumented dbms_json_int.rename( indexname IN VARCHAR2, path IN VARCHAR2, type IN NUMBER, preferred_name IN VARCHAR2);

TBD