Re: Circular Invalid Package Issue
Date: Thu, 07 Aug 2008 15:39:06 +1000
"Ana C. Dent" <anacedent_at_hotmail.com> writes:
> Chris S <cjsommer_at_gmail.com> 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 auReceived on Thu Aug 07 2008 - 00:39:06 CDT