Re: Recompiling tool

Dear mr DerWoud,

SQLTools has an option to recompile all invalid objects:

Integrated server-side SQL & PL/SQL development environment for Oracle developers, easily browsing the Oracle database, programming and debugging PL/SQL stored program units like packages, procedures, functions, database-triggers and so on.

We would like to invite you to have a look at our website (www.sequel.nl) and download the free trial software.

Sincerely,

Arthur Kolkman (Sequel Solutions)

DerWoud wrote:

> Put yourself together a script to look at user_objects (or all_objects)
> where the object_type is a package, proc or function, and the status is
> invalid. Spool these names wrapped in the text to alter <type>.<name>
> compile; then have that same script run the spooled file. I can e-mail you
> what I use if you want it.
> DerWoud
>
> Jan Kjetil wrote in message <356938E2.F2CB4862_at_nextel.no>...
> >I have a database with many dependencies among the packages with PL/SQL
> >code.
> >When a package is recompiled the dependent code packages are set
> >to invalid even if the compiled package is valid.
> >
> >Does anybody know about any recompiling tool for Oracle which can
> >be helpful in this situation?
> >
> >
> >jka_at_nextel.no
> >
Received on Sun May 31 1998 - 03:24:11 CDT