Oracle | DBMS_JSON

Oracle DBMS_JSON_DUALITY Version 23c

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 Interface that will be used by the REST implementation for multi-operation serializable transactions.

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT

DBMS_STANDARD

Documented Yes

Exceptions

Error Code	Reason
ORA-08178	Illegal SERIALIZABLE clause specified for user INTERNAL

First Available 23.2

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(DEFAULT, NONE);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsdv,sql
{ORACLE_HOME}/rdbms/admin/prvt.plb

Subprograms

BEGIN_TRANSACTION	GET_ETAG	REGISTER
COMMIT_TRANSACTION

BEGIN_TRANSACTION (new 23c)

Begin a duality view serializable transaction dbms_json_duality.begin_transaction;

exec dbms_json_duality.begin_transaction;

      *

      ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

      ORA-06512: at "SYS.DBMS_JSON_DUALITY", line 9

      ORA-06512: at line 1

COMMIT_TRANSACTION (new 23c)

Commit a duality view serializable transaction dbms_json_duality.commit_transaction;

exec dbms_json_duality.commit_transaction;

      

      PL/SQL procedure successfully completed.

GET_ETAG (new 23c)

Return the etag for an object dbms_json_duality.get_etag( view_name IN VARCHAR2, oid IN RAW, etag OUT RAW);

TBD

Register an object for modification in a duality view serializable transaction dbms_json_duality.register( view_name IN VARCHAR2, oid IN RAW, etag OUT RAW);

TBD