PLS-00302 in

From: supernova <nova67f_at_yahoo.de>
Date: 7 Dec 2006 12:33:19 -0800
Message-ID: <1165523599.749566.118000@79g2000cws.googlegroups.com>

Hi,

i'm trying to run the DBMS_REPAIR check routine but i get a PLS-00302 error.
Can any1 help?

thks, Andy

SET SERVEROUTPUT ON
DECLARE CORRUPTED_BLOCKS INT;
BEGIN
CORRUPTED_BLOCKS := 0;
DBMS_REPAIR.CHECK_OBJECTS(

    SCHEMA_NAME        => 'SH1' ,
    OBJECT_NAME        => 'ACSALES',
    REPAIR_TABLE_NAME  => 'REPAIR_TABLE1',
    CORRUPT_COUNT      => CORRUPTED_BLOCKS
                    );

DBMS_OUTPUT.PUT_LINE('You have ' || TO_CHAR(CORRUPTED_BLOCKS) || ' corrupt block(s)');
END;
/

Error at line 2

ORA-06550: Ligne 4, colonne 13 :
PLS-00302: Le composant 'CHECK_OBJECTS' doit être déclaré
ORA-06550: Ligne 4, colonne 1 :

PL/SQL: Statement ignored Received on Thu Dec 07 2006 - 14:33:19 CST