Oracle | PRIVATE_JDBC

Oracle PRIVATE_JDBC_DR Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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 23ai)

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