When doing the ORACLE DBMS_CHANGE_NOTIFICATION experiments, found himself inside the database does not implement the package (with PL/SQL developer open, didn't find this package)

And then to find information on the web, found that implementation of statements, in/RDBMS/ADMIN/DBMSCHNF SQL inside, then I put the inside of the sentence is to compile time, the package, but there were no inclusions, and then do some steps, always prompt can not find the inclusions, the inclusions in where to find?

Or say my database has a problem? Normal open are commonly shows all packages and inclusions?

CodePudding user response:

The installation of the packages are shipped

CodePudding user response:

Find the reason, because I didn't use sys account login, the built-in package only sys account under have a body, so with other users will not be found

CodePudding user response:

Or by using sys user authorization