Re: Stored procs failing
Date: 1 Jan 1995 15:03:32 GMT
Message-ID: <3e6g84$5gu_at_cpccux0.cphk.hk>
L. Carl Pedersen (l.carl.pedersen_at_dartmouth.edu) wrote:
: In article <3e22aq$ecc_at_nsmmfs07.nsm.ac.com>, lothmar_at_cscoe.ac.com wrote:
: 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.
When a procedure reference a view or something, drop or recreate the view (or something) will cause oracle to invalidate the procedure and need to recompile it to make sure the procedure still reference the correct things. So an import will make those procedure invalid. But I really don't know about Oracle 7.1.4, so try to recompile it and good luck. Henry. Received on Sun Jan 01 1995 - 16:03:32 CET