Re: How to recompile all my stored procedures ?

fmarchioni_at_libero.it wrote:
> Hi Oracle users,
> I'm again asking your opinion about pl-sql.
> Does anybody know how to recompile all stored procedures
> in one shot using a batch file ?
>
> One step back. We have all stored procedures versioned on CVS.
> Every time there's a new release of our application
> I'd like to validate all pl-sql packages found on CVS
> because it can happen that somebody forgot to "check in" changes to
> procedures.
>
> So this is the scenario. How would you validate in batch all procedures
> ?
>
> (Ps I cannot simply import all .sql files in toad and validate them.
> I'd like rather, if possible, to integrate it with the batch file we
> use to build Java classes)
>
> Thanks
> Francesco

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

Don't reinvent the wheel.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)