Oracle Database Discussions

Hi,

On 11.2.04 on UNIX

I have the following invalide object:

select object_name,object_type, status, owner from dba_objects where OBJECT_NAME='AZ_COMP_REPORTER';

OBJECT_NAME OBJECT_TYPE STATUS OWNER

-------------------------------------------------------------------------------------------------------------------------------- ------------------- -------

AZ_COMP_REPORTER PACKAGE BODY INVALID APPS

Then I try to compile:

SQL> alter package apps.AZ_COMP_REPORTER compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err

Errors for PACKAGE BODY APPS.AZ_COMP_REPORTER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

126/10 PL/SQL: ORA-04063: view "AZ.AZ_DIFF_RESULTS#" has errors

I see in sql devloper:

Then I run:

select count(*) from AZ.AZ_DIFF_RESULTS;

Erreur SQL : ORA-04063: table "AZ.AZ_DIFF_RESULTS" has errors

04063. 00000 - "%s has errors"

*Cause: Attempt to execute a stored procedure or use a view that has

       errors.  For stored procedures, the problem could be syntax errors

       or references to other, non-existent procedures.  For views,

       the problem could be a reference in the view's defining query to

       a non-existent table.

       Can also be a table which has references to non-existent or

       inaccessible types.

*Action: Fix the errors and/or create referenced objects as necessary.

How to find the errors on AZ.AZ_DIFF_RESULTS table?

Thanks