Re: Stored procs failing
Date: Sat, 31 Dec 1994 00:06:53 -0500
Message-ID: <l.carl.pedersen-3112940006530001_at_kip-2-sn-292.dartmouth.edu>
In article <3e22aq$ecc_at_nsmmfs07.nsm.ac.com>, lothmar_at_cscoe.ac.com wrote:
> 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!!
>
i'm not sure why, but i often find a few invalid stored procedures after
an import. alter procedure foobar compile fixes it. i suspect it has
something to do with running out of shared pool, but that's just a guess.
Received on Sat Dec 31 1994 - 06:06:53 CET