SQL> SELECT OWNER,OBJECT_NAME,ORACLE_MAINTAINED FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'TYPE' AND OBJECT_NAME = 'KU$_VCNT';

OWNER      OBJECT_NAME     ORACLE_MAINTAINED
---------- --------------- -----------------
SYS        KU$_VCNT        Y

SQL> SELECT DBMS_METADATA.GET_DDL('TYPE', 'KU$_VCNT','SYS') FROM dual;

DBMS_METADATA.GET_DDL('TYPE','KU$_VCNT','SYS')
--------------------------------------------------------------------------------

  CREATE OR REPLACE NONEDITIONABLE TYPE "SYS"."KU$_VCNT"


SQL> SELECT OWNER,OBJECT_NAME,ORACLE_MAINTAINED FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'TYPE' AND OBJECT_NAME LIKE 'SYS_PLSQL%' AND ROWNUM = 1;

OWNER      OBJECT_NAME               ORACLE_MAINTAINED
---------- ------------------------- -----------------
SYS        SYS_PLSQL_C80B37C8_228_1  Y

SQL> SELECT DBMS_METADATA.GET_DDL('TYPE', 'SYS_PLSQL_C80B37C8_228_1','SYS') FROM dual;
ERROR:
ORA-31603: object "SYS_PLSQL_C80B37C8_228_1" of type TYPE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 6478
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6465
ORA-06512: at "SYS.DBMS_METADATA", line 9202
ORA-06512: at line 1

no rows selected

SQL>

SQL> connect u1@pdb1sol122
Enter password:
Connected.
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE    12.2.0.1.0      Production
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

SQL> select object_name from user_objects;

no rows selected

SQL> CREATE OR REPLACE
  2    PACKAGE pkg_cl_risk_eval
  3      AS
  4        TYPE cl_risk_type
  5          IS RECORD(
  6                    adate date,
  7                    cid   number(10),
  8                    indicatorid number(5),
  9                    value number(5)
 10                   );
 11        TYPE cl_risk_act IS TABLE OF cl_risk_type;
 12        FUNCTION sample(
 13                        p_date date,
 14                        p_indicatorid number,
 15                        p_ismodel number
 16                       )
 17          return cl_risk_act
 18          pipelined;
 19   END;
 20  /

Package created.

SQL> CREATE OR REPLACE
  2    PACKAGE BODY pkg_cl_risk_eval
  3      is
  4        FUNCTION sample(
  5                        p_date date,
  6                        p_indicatorid number,
  7                        p_ismodel number
  8                       )
  9          return cl_risk_act
 10          pipelined
 11          IS
 12              v_obj cl_risk_type;
 13          BEGIN
 14               FOR e IN (select trunc(sysdate) adate,0 cid,0indicatorid,case when p_ismodel = 0 then 0 else 1 end value from dual) LOOP
 15                 v_obj.adate        := e.adate;
 16                 v_obj.cid            := e.cid;
 17                 v_obj.indicatorid := e.indicatorid;
 18                 v_obj.value        := e.value;
 19                 PIPE ROW (v_obj);
 20               END LOOP;
 21               RETURN;
 22          end;
 23  end;
 24  /

Package body created.

SQL> select object_name,object_type from user_objects;

OBJECT_NAME                    OBJECT_TYPE
------------------------------ -----------------------
SYS_PLSQL_EEB4195C_41_1        TYPE
SYS_PLSQL_EEB4195C_DUMMY_1     TYPE
SYS_PLSQL_EEB4195C_9_1         TYPE
PKG_CL_RISK_EVAL               PACKAGE
PKG_CL_RISK_EVAL               PACKAGE BODY

SQL> SELECT DBMS_METADATA.GET_DDL('TYPE','SYS_PLSQL_EEB4195C_41_1') FROM DUAL;
ERROR:
ORA-31603: object "SYS_PLSQL_EEB4195C_41_1" of type TYPE not found in schema "U1"
ORA-06512: at "SYS.DBMS_METADATA", line 6478
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6465
ORA-06512: at "SYS.DBMS_METADATA", line 9202
ORA-06512: at line 1



no rows selected

SQL>

SQL> SELECT OBJECT_NAME,SHARING FROM DBA_OBJECTS WHERE OBJECT_TYPE = 'TYPE' AND OBJECT_NAME LIKE 'SYS_PLSQL%' AND ROWNUM = 1;

OBJECT_NAME                    SHARING
------------------------------ ------------------
SYS_PLSQL_C80B37C8_228_1       METADATA LINK

SQL> SELECT * FROM DBA_TYPES WHERE TYPE_NAME = 'SYS_PLSQL_C80B37C8_228_1';

no rows selected

SQL> DESC SYS.SYS_PLSQL_C80B37C8_228_1
ERROR:
ORA-04043: object SYS.SYS_PLSQL_C80B37C8_228_1 does not exist


SQL>