Oracle 18cR3 DBMS

Oracle DBMS_JSON0 Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose JSON related utilities

AUTHID DEFINER

Dependencies

COL$	DBMS_OUTPUT	USER$
COM$	DBMS_SYS_ERROR	V$PARAMETER
DBMS_JSON	OBJ$

Documented No

First Available 12.2.0.1

Security Model Owned by SYS with EXECUTE granted to XDB

This package, as of 18c, uses an ACCESSIBLE BY clause to block any attempts at direct access as seen in the demos below.

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

Subprograms

CHECKCOMPAT	GETINDEXINFO	RAISEERROR
CHECKVCNAME	GETJSONFORMAT	RAISEERRORMESG

CHECKCOMPAT

Undocumented dbms_json0.checkCompat;

exec dbms_json0.checkCompat;

           *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_JSON0

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

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

RAISEERROR

Undocumented

Overload 1 dbms_json0.raiseError(err IN NUMBER);

TBD

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

TBD

RAISEERRORMESG (new 18c)

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');

           *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object DBMS_JSON0

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored