I am working with Oracle 12.1.0.2.0
When creating a pipelined function within a package and using a return type tab_table_type (definition: "type tab_table_type is table of tab%rowtype;") oracle is creating the type for the return value.
These types are starting with SYS_PLSQL and can be found using DBA_OBJECTS.
Where can I find the Parent of these kind of types. They cannot be found with DBA_DEPENDENCIES.
N.B. When I have a separate schema with the same package Oracle create the types also on the other schema and I cannot remove or replace the package anymore.
This is the reason why I want to know the parents of the SYS_PLSQL types.
Regards,
fred.