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

3

Related questions 1 What is meant by an object when you talk about databases? 0 Which db type has to used when passing an object to procedure in a oracle package using ODP.NET (C #)? 0 PL/SQL Package and Package Body Related questions 1 What is meant by an object when you talk about databases? 0 Which db type has to used when passing an object to procedure in a oracle package using ODP.NET (C #)? 0 PL/SQL Package and Package Body 0 When to use Oracle Objects (User Defined Types)? 3 Difference between Synonyms in oracle 3 Oracle package specs and body 1 Difference between all_mviews and dba_mviews 2 Oracle record type vs object 1 Oracle Object Types 1 initializing schema object type vs. package type Load 7 more related questions Show fewer related questions

Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.