PL/SQL (MOSC)

MOSC Banner

package compiles in 1 database and not another of same version

edited Feb 28, 2012 11:16AM in PL/SQL (MOSC) 3 commentsAnswered

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                                                  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center