I have created one package in my schema. I am able to see the new package under the all_objects but dba_object is not giving any result.
SELECT * FROM DBA_OBJECTS WHERE OBJECT_NAME='UT_AIP_FX_AGGREGATED_ORDER_PKG';
-- No row fetched.
SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME='UT_AIP_FX_AGGREGATED_ORDER_PKG';
-- giving the result.
according to dba_objects definition my 1st query also should return the result ?
I am using below oracle version. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production PL/SQL Release 12.2.0.1.0 - Production