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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_JSON
DBMS_JSON_INT
JSON Functionality
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx