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 is now availble. If you haven't you downloaded already: Why?

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