Skip to Main Content
  • Questions
  • ALL_OBJECTS/DBA_OBJECTS not displaying results when used in Proceudre

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Thomas.

Asked: July 26, 2018 - 1:23 pm UTC

Last updated: July 27, 2018 - 1:46 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi,

I was having a weird issue. I wanted to use the ALL_OBJECTS or DBA_OBJECTS to check the existence of an object on a different schema in my database. When I query the database, I'm able to see the object. However when I execute the same query using a procedure inside a package, created in my schema, the same query does not return any result. In fact only objects in my schema show up when used in the procedure. Also when I use DBA_OBJECTS and try to compile the package-body/procedure, I get error stating table/view does not exist.

Any input is much appreciated.

Thanks in advance!

and Connor said...


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.