Re: Stored procs failing

In article <3e22aq$ecc_at_nsmmfs07.nsm.ac.com> lothmar_at_cscoe.ac.com (Mark Loth - DBA) writes:

> Recently I performed an upgrade from 7.0.16.6 to 7.1.4 for a project group. Once the
> upgrade had been successfully been installed, I did a full database import to recreate
> the database. Everything seemed fine until I received a message the next day that
> several stored procs were invalid. Because I was not familiar with their database, I
> have no idea whether the procs were valid or invalid before the upgrade.
>
> Is it possible that the upgraded version is not compatiable with some old procs or
> could the export have any effect on their status? Any help would be greatly
> appreciated!!

When the import program recreates the stored procedures/packages, they are recreated according to the object# at time of export (or some other sequence). If you have dependencies in the stored procedures (one referencing the other) and they are created out of sequence, the dependents are marked as invalid during creation because the dependees (or whatever term it is) are not yet created. Recompiling the invalid procedures would get rid of this problem.

--
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Applications Division ... Oracle Corporation |
|  Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel