Database Tuning (MOSC)

MOSC Banner

Error while comping package

edited Feb 8, 2011 10:54PM in Database Tuning (MOSC) 5 commentsAnswered
Hi all,

I am getting below error while compiling package,

can anyone help me on this,

it's urgent...



SQL> alter package INV_UI_ITEM_SUB_LOC_LOVS compile;

Warning: Package altered with compilation errors.

SQL> show errors
No errors.
SQL> alter package INV_UI_ITEM_SUB_LOC_LOVS compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY INV_UI_ITEM_SUB_LOC_LOVS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
463/9 PL/SQL: SQL Statement ignored
465/11 PL/SQL: ORA-00904: "A"."LOCATOR_SEGMENTS": invalid identifier
478/9 PL/SQL: SQL Statement ignored
480/11 PL/SQL: ORA-00904: "LOCATOR_SEGMENTS": invalid identifier

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