PL/SQL (MOSC)

MOSC Banner

PLSQL not compiling

edited Mar 30, 2010 8:47AM in PL/SQL (MOSC) 3 commentsAnswered ✓
Hi

-

I'm running on a database 10.2.0.4 and I when I try to compile packages the rdbms add an extra owner to the objects. for example:

-

SYS/fonatopdes> alter package topaz.PKG_BORRADO_INC_CREDITOS compile body;

Warning: Package Body altered with compilation errors.

SYS/fonatopdes> show err
Errors for PACKAGE BODY TOPAZ.PKG_BORRADO_INC_CREDITOS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
10/10    PL/SQL: Statement ignored
10/16    PLS-00905: object TOPAZ.TOPAZ is invalid

Where: TOPAZ is the owner and it's duplicated when compiling.

-

I have check this parameters, but compare them with aother database, where plsql code runs fine, they look 0k:

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