Implicitly created TYPE object comparison between 11g & 12c+
From: DOUG KUSHNER <dougk5_at_cox.net>
Date: Fri, 31 Mar 2023 08:37:15 -0700 (MST)
Message-ID: <2104256447.156565.1680277035728_at_myemail.cox.net>
Our developers have created packages that define a type. Upon package creation, 3 type objects are implicitly created in the package owner's schema, all with name 'SYS_PLSQL%'.
Date: Fri, 31 Mar 2023 08:37:15 -0700 (MST)
Message-ID: <2104256447.156565.1680277035728_at_myemail.cox.net>
Our developers have created packages that define a type. Upon package creation, 3 type objects are implicitly created in the package owner's schema, all with name 'SYS_PLSQL%'.
In 11.2.0.4, the names are similar to the following, where '3557076' is the package's object_id.
SYS_PLSQL_3557076_DUMMY_1 SYS_PLSQL_3557076_27_1 SYS_PLSQL_3557076_9_1
In 12.1, the type name does not contain the parent object's id, but some unknown hex value.
SYS_PLSQL_8642B728_9_1 SYS_PLSQL_8642B728_DUMMY_1 SYS_PLSQL_8642B728_27_1
Does anyone know how to find the parent package's object_id in 12.1 and later versions?
Regards,
Doug
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 31 2023 - 17:37:15 CEST