Oracle | DBMS

Oracle DBMS_JSON0 Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

Security Model Owned by SYS with EXECUTE granted to XDB

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

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

Subprograms

CHECKCOMPAT	GETINDEXINFO	RAISEERROR
CHECKPK	GETJSONFORMAT	RAISEERRORMESG
CHECKVCNAME	GETMAXVCSIZE

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

CHECKPK (new 21c)

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;

      /

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

GETMAXVCSIZE (new 21c)

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

SELECT dbms_json0.getMaxVCSize

      FROM dual;

      SELECT dbms_json0.getMaxVCSize

      *

      ERROR at line 1:

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

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

           *

      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