Re: PLS-00302 in

supernova wrote:
> 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

Note ... after you create the repair table to get rid of it you must:

exec dbms_repair.admin_tables('REPAIR_TABLE',1,3);

The action flags, the third parameter, are:

CREATE_ACTION  	BINARY_INTEGER  1
DROP_ACTION 	BINARY_INTEGER 	3
PURGE_ACTION 	BINARY_INTEGER 	2

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org