package compiles in 1 database and not another of same version
I have databases, both version 11.2.0.3, both running out of the same ORACLE_HOME on the same server. A package that compiles and runs in one database (WORKS) will not compile in the other (BROKE). I've checked the init parameters for the 2 databases and the first difference that I see is the compatible setting in WORKS is 11.2.0 and in BROKE is 11.2.0.3.0. Could this cause the problem? What else can I check?
Thanks in advance,
Susan
The errors from the failed compile are:
SQL> sho errors
Errors for PACKAGE BODY SLS_FIND_PRIVS_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/1 PL/SQL: Item ignored