Skip to Content
0
Mar 30, 2008 at 09:48 AM

Invalid object

280 Views

Hi,

in a BI system just copied I found some invalid object, I post the output of : SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';

/BI0/0400027280

/BI0/0400003010

/BI0/0400018987

/BI0/0400002996

/BI0/0400007708

/BI0/0400031992

/BI0/0400027879

/BI0/0400027880

/BI0/0400027128

/BI0/0400027852

/BI0/0400027853

/BI0/0400027906

/BI0/0400027907

/BI0/0400029629

All obj are PROCEDURE and are in ABAP schema... I try with: alter <object_type> schemaname.<object_name> compile;

withour success ... Oracle see: procedure not found.

Any idea ?

Regards.

Ganimede Dignan.