Oracle | DBMS

Oracle DBMS_JSON0 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 JSON related utilities

AUTHID DEFINER

Dependencies

DBA_TAB_COLS	DBMS_JSON	DBMS_SYS_ERROR
DBMS_ASSERT	DBMS_OUTPUT	V$PARAMETER

Documented No

First Available 12.2

Security Model Owned by SYS with EXECUTE granted to XDB

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

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

Subprograms

CHECKCOMPAT	GETMAXVCSIZE	JSON_MIG_PRECHECK_PROCESS
CHECKMVIEXISTS	JSON_MIG_CREATE_STTAB	JSON_MIG_SAVE_STATUS
CHECKPK	JSON_MIG_PRECHECK	JSON_MIG_VERIFY_STTAB
CHECKVCNAME	JSON_MIG_PRECHECK_BLOB	RAISEERROR
GETINDEXINFO	JSON_MIG_PRECHECK_CLOB	RAISEERRORMESG
GETJSONFORMAT	JSON_MIG_PRECHECK_FAST	SODACOLLEXISTS
GETMAXCOL	JSON_MIG_PRECHECK_FULL

CHECKCOMPAT

Undocumented dbms_json0.checkCompat;

exec dbms_json0.checkCompat;

           *

      PLS-00904: insufficient privilege to access object DBMS_JSON0

CHECKMVIEXISTS (new 23ai)

Undocumented dbms_json0.checkMViExists( owner IN VARCHAR2, index_name IN VARCHAR2);

TBD

CHECKPK

Returns TRUE when the called by DBMS_JSON and the table has a Primary Key dbms_json0.checkPK( OWNER IN VARCHAR2, TABLENAME IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_json0.checkPK(USER, 'TAB$') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      PLS-00904: insufficient privilege to access object DBMS_JSON0

CHECKVCNAME

Undocumented dbms_json0.checkVCName( vcname IN VARCHAR2, owner IN VARCHAR2, tname IN VARCHAR2, cname IN VARCHAR2) RETURN BOOLEAN;

TBD

GETINDEXINFO

Undocumented dbms_json0.getIndexInfo( owner IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2, indexname IN VARCHAR2)

TBD

GETJSONFORMAT

Undocumented dbms_json0.getJSONFormat( owner IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2) RETURN NUMBER;

TBD

GETMAXCOL (new 23ai)

Undocumented dbms_json0.getMaxCol RETURN NUMBER;

SELECT dbms_json0.getMaxCol;

      *

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

GETMAXVCSIZE

Returns the maximum size, in bytes, of a VARCHAR2 when called by DBMS_JSON dbms_json0.getMaxVCSize RETURN NUMBER;

SELECT dbms_json0.getMaxVCSize;

      *

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

JSON_MIG_CREATE_STTAB (new 23ai)

Undocumented dbms_json0.json_mig_create_sttab( owner IN VARCHAR2, tablename IN VARCHAR2, append IN BOOLEAN, tableexists IN BOOLEAN);

TBD

JSON_MIG_PRECHECK (new 23ai)

Undocumented dbms_json0.json_mig_precheck( admin IN VARCHAR2, owner IN VARCHAR2, tableName IN VARCHAR2, columnName IN VARCHAR2, statusTableName IN VARCHAR2, fastCheck IN BOOLEAN);

TBD

JSON_MIG_PRECHECK_BLOB (new 23ai)

Undocumented dbms_json0.json_mig_precheck_blob( admin IN VARCHAR2, owner IN VARCHAR2, tableName IN VARCHAR2, columnName IN VARCHAR2, totalColumns IN NUMBER, statusFreq IN NUMBER, errorCount IN OUT NUMBER, statusTableName IN VARCHAR2, fastCheck IN BOOLEAN);

TBD

JSON_MIG_PRECHECK_CLOB (new 23ai)

Undocumented dbms_json0.json_mig_precheck_clob( admin IN VARCHAR2, owner IN VARCHAR2, tableName IN VARCHAR2, columnName IN VARCHAR2, totalColumns IN NUMBER, statusFreq IN NUMBER, errorCount IN OUT NUMBER, statusTableName IN VARCHAR2, fastCheck IN BOOLEAN);

TBD

JSON_MIG_PRECHECK_FAST (new 23ai)

Undocumented dbms_json0.json_mig_precheck_fast( admin IN VARCHAR2, owner IN VARCHAR2, tableName IN VARCHAR2, columnName IN VARCHAR2, colCount IN NUMBER, totalColumns IN NUMBER, statusFreq IN NUMBER, errorCount IN OUT NUMBER, statusTableName IN VARCHAR2, fastCheck IN BOOLEAN, rowIDCol IN ROWID, clobData IN CLOB, blobData IN BLOB);

TBD

JSON_MIG_PRECHECK_FULL (new 23ai)

Undocumented dbms_json0.json_mig_precheck_full( admin IN VARCHAR2, owner IN VARCHAR2, tableName IN VARCHAR2, columnName IN VARCHAR2, colCount IN NUMBER, totalColumns IN NUMBER, statusFreq IN NUMBER, errorCount IN OUT NUMBER, statusTableName IN VARCHAR2, fastCheck IN BOOLEAN, rowIDCol IN ROWID, clobData IN CLOB, blobData IN BLOB);

TBD

JSON_MIG_PRECHECK_PROCESS (new 23ai)

Undocumented dbms_json0.json_mig_precheck_process( admin IN VARCHAR2, owner IN VARCHAR2, tableName IN VARCHAR2, columnName IN VARCHAR2, OSONszRes IN NUMBER, totalColumns IN NUMBER, statusFreq IN NUMBER, colnum IN NUMBER, errorCount IN OUT NUMBER, statusTableName IN VARCHAR2, rowIDCol IN ROWID, isJSONchk IN NUMBER, errorCode IN VARCHAR2, fastCheck IN BOOLEAN);

TBD

JSON_MIG_SAVE_STATUS (new 23ai)

Undocumented dbms_json0.json_mig_save_status( admin IN VARCHAR2, statusTableName IN VARCHAR2, owner IN VARCHAR2, tableName IN VARCHAR2, columnName IN VARCHAR2, status IN VARCHAR2, error_code IN VARCHAR2, row_id IN ROWID);

TBD

JSON_MIG_VERIFY_STTAB (new 23ai)

Undocumented dbms_json0.json_mig_verify_sttab( owner IN VARCHAR2, tableName IN VARCHAR2, tableExists OUT BOOLEAN);

TBD

RAISEERROR

Undocumented

Overload 1 dbms_json0.raiseError(err IN NUMBER);

TBD

Overload 2 dbms_json0.raiseError( err IN NUMBER, arg1 IN VARCHAR2);

TBD

RAISEERRORMESG

Raises an application defined exception with error number and message dbms_json0.raiseErrorMesg( err IN NUMBER, mesg IN VARCHAR2);

exec dbms_json0.raiseErrorMesg(20001, 'Test Exception');

           *

      PLS-00904: insufficient privilege to access object DBMS_JSON0

SODACOLLEXISTS (new 23ai)

Undocumented dbms_json0.sodaCollExists( owner IN VARCHAR2, tableName IN VARCHAR2) RETURN BOOLEAN;

DECLARE

       retVal BOOLEAN;

      BEGIN

        IF dbms_json0.sodaCollExists(('SYS', 'TAB$') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      PLS-00904: insufficient privilege to access object DBMS_JSON0