SYS_PLSQL_object_id

admin

SYS@ora11> select owner,object_name,object_type,status FROM DBA_OBJECTS where object_id=8857;

OWNER               OBJECT_NAME            OBJECT_TYPE        STATUS
------------------------------ -------------------------------- ------------------- -------
SYS                   PRIVATE_JDBC            PACKAGE         VALID

private_jdbc.sql creates a package with types and procedures that are used
internally by the JDBC thin driver to support ADT and other PLSQL collection
types.

This is the beginning of the script:

CREATE OR REPLACE PACKAGE PRIVATE_JDBC AUTHID CURRENT_USER AS
TYPE SHAPE_REC is RECORD(
  schema_name DBMS_QUOTED_ID,
  typename DBMS_QUOTED_ID,
  typecode DBMS_QUOTED_ID,
  typoid  RAW(4000),
  version NUMBER,
  tds     RAW(4000));

  TYPE SHAPES is TABLE OF SHAPE_REC;

  TYPE TYPE_ID_REC IS RECORD (
    typename DBMS_QUOTED_ID,
    typecode DBMS_QUOTED_ID
  );

  TYPE TYPE_CUR IS REF CURSOR RETURN TYPE_ID_REC;

  FUNCTION GET_ALL_TYPE_SHAPE_INFO(owner_names IN VARCHAR2, type_names IN
VARCHAR2)
    RETURN SHAPES PIPELINED;

  FUNCTION GET_TYPE_SHAPE_INFO
    RETURN SHAPES PIPELINED ;

  FUNCTION GET_TYPE_SHAPE_INFO( type_names IN VARCHAR2 )
    RETURN SHAPES PIPELINED;