This content has been marked as final. Show 2 replies
When you are trying to alter and compile the package, are you connected as user PIRAMIDE? If not then you should preface the package name with the user name, like:
ALTER PACKAGE PIRAMIDE.PCK_PIR_NFEL_MILLENIUM COMPILE;
You will also need to make sure that you have privileges to alter a package in another schema.
Also, this question really does not have anything to do with Oracle Objects, so probably belongs in the SQL and PL/SQL forum.