Re: Circular Invalid Package Issue

From: Tim X <>
Date: Thu, 07 Aug 2008 15:39:06 +1000
Message-ID: <>

"Ana C. Dent" <> writes:

> Chris S <> wrote in news:336994bd-9d55-4e8a-831b-
> IIRC, there is an initSID.ora parameter which includes the string
> "SIGNATURE". The default is "off" & you get the behavior described.
> After changing it to be "on", packages will only go invalid when the
> number or datatype of parameters changes.

Note however, I don't believe this works with client PL/SQL code, which I believe can only use the old/default timestamp based method. this doesn't seem to apply wrt the OPs problem, but thought I'd mention it for completeness.


tcross (at) rapttech dot com dot au
Received on Thu Aug 07 2008 - 00:39:06 CDT

Original text of this message