-
edit packages standard
Hey DBA. I got one for ya.
I use Oracle 9i enterprise manager to interface with a oracle 8.1.7 database. At loggin to EM I get a list of invalid packages. After going through the process of package veryfication I get the standard & dbms_standard packages are invalid. As you know, urlrp.sql(UTiLity script Recompile invalid Pl/sql modules) script cannot be run until both these packages are valid. Is there a way to trackdown the errors in the standard packages and edit them? Are there any issues that arise from the different versions.
-
DBMS_STANDARD
Hi Garry.
Please provide the PLSQL_V2_COMPATIBILITY parameter value, try to change it to FALSE and try to compile your package again.
Who is the owner of this package?
Also try to run again the standard.sql script with SYS user, if you can't compile your package.
HTH.
Best regards.
-
Have you tried just using "ALTER PACKAGE ... COMPILE"?
Editting these packages would be a very bad thing.