Oracle DBMS_JSON_INT
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 Internal JSON support utilities
AUTHID CURRENT_USER
Dependencies
DBMS_JSON DBMS_JSON_LIB  
Documented No
First Available 12.2
Security Model Owned by XDB with no privileges granted

Direct access to some objects in this package is prevented by means of an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvtjson.plb
Subprograms
 
ADDVC
Add a virtual column dbms_json_int.addVC(
owner     IN VARCHAR2,
tablename IN VARCHAR2,
jcolname  IN VARCHAR2,
indexname IN VARCHAR2,
frequency IN NUMBER,
hidden    IN BOOLEAN);
CREATE TABLE j_purchase_order(
doc_id      RAW (16) NOT NULL,
date_loaded TIMESTAMP(6) WITH TIME ZONE,
po_document CLOB);

SELECT DISTINCT defer, condition
FROM cdef$;

ALTER TABLE j_purchase_order
ADD CONSTRAINT ensure_json
CHECK (po_document IS JSON);

exec xdb.dbms_json_int.addVC(USER, 'J_PURCHASE_ORDER', 'po_document', NULL, NULL, TRUE);
 
BLOB2JSON (new 21c)
See DBMS_JSON.

Protected by an ACCESSIBLE BY clause
dbms_json_int.blob2json(
owner      IN VARCHAR2,
tablename  IN VARCHAR2,
columnname IN VARCHAR2,
throwerror IN BOOLEAN);
See DBMS_JSON.BLOB_TO_JSON
 
CHECKPRIVILEGE
Undocumented dbms_json_int.checkPrivilege(
uname     IN VARCHAR2,
owner     IN VARCHAR2,
tablename IN VARCHAR2);
TBD
 
CREATEVIEWONPATH
Undocumented dbms_json_int.createViewOnPath(
owner        IN VARCHAR2,
viewname     IN VARCHAR2,
tablename    IN VARCHAR2,
jcolname     IN VARCHAR2,
path         IN VARCHAR2,
indexname    IN VARCHAR2,
frequency    IN NUMBER,
resourcepath IN VARCHAR2,
materialize  IN BOOLEAN);
TBD
 
DROPVC
Drop a virtual column dbms_json_int.dropVC(
owner     IN VARCHAR2,
tablename IN VARCHAR2,
jcolname  IN VARCHAR2,
indexname IN VARCHAR2);
TBD
 
GENDATAGUIDE
  dbms_json_int.genDataGuide(
dgtabname        IN VARCHAR2,
tabviewname      IN VARCHAR2,
jcolname         IN VARCHAR2,
estimate_percent IN NUMBER);
TBD
 
GETDATAGUIDE
  dbms_json_int.getDataGuide(
owner     IN     VARCHAR2,
indexname IN     VARCHAR2,
format    IN     NUMBER,
dataguide IN OUT CLOB);
TBD
 
PJCOLINM
  dbms_json_int.pjcolinm(
owner    IN VARCHAR2,
tabname  IN VARCHAR2,
jcolname IN VARCHAR2,
format   IN VARCHAR2);
TBD
 
RENAME
  dbms_json_int.rename(
indexname      IN VARCHAR2,
path           IN VARCHAR2,
type           IN NUMBER,
preferred_name IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_JSON
DBMS_JSON0
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