Recompile invalid prcedures -- help needed

From: Dr Yufan Hu <yufan_at_rightiming.com>
Date: 3 Jan 2000 22:35:54 GMT
Message-ID: <84r88a$bjh$1@news.rightiming.com>

Hello,

From Oracle Schema Manager I noticed from time to time that some of the stored procedures and Packages became invalid. Although I can recompile these invalid procedures from the Schema Manager by click one procedure after another, I would like to find out how I can do it through SQL. Executing the output of following SQL statement:

select unique 'ALTER PROCEDURE ' || NAME || ' COMPILE;' from user_source

where TYPE='PROCEDURE';

does not seem to work. It creates more invalide procedures.

Any help greately appreciated.

Yufan Received on Mon Jan 03 2000 - 16:35:54 CST