Oracle | PRIVATE_JDBC

Oracle PRIVATE_JDBC_DR 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 Returns the value of the compatible parameter

AUTHID DEFINER

Dependencies

PRIVATE_JDBC

V$PARAMETER

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted

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

Subprograms

GET_COMPATIBLE

GET_MAX_STRING_SIZE

GET_COMPATIBLE

Returns the COMPATIBLE parameter for the spfile private_jdbc_dr.get_compatible RETURN VARCHAR2;

SQL> show parameter compatible

      

      NAME               TYPE     VALUE

      ------------------ -------- --------

      compatible         string   23.0.0

      noncdb_compatible  boolean  FALSE

      

      

      SELECT private_jdbc_dr.get_compatible;

      

      GET_COMPATIBLE

      ---------------

      23.0.0

GET_MAX_STRING_SIZE (new 23c)

Returns STANDARD or EXTENDED private_jdbc_dr.get_max_string_size RETURN VARCHAR2;

SQL> show parameter string

      

      NAME               TYPE     VALUE

      ------------------ -------- --------

      asm_diskstring     string

      max_string_size    string   EXTENDED

      

      SELECT private_jdbc_dr.get_compatible;

      

      GET_COMPATIBLE

      ---------------

      EXTENDED