Oracle | DBMS

Oracle DBMS_JSON0 Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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