Re: Circular Invalid Package Issue

"Ana C. Dent" <anacedent_at_hotmail.com> writes:

> Chris S <cjsommer_at_gmail.com> wrote in news:336994bd-9d55-4e8a-831b-
> ffd15bc5b0fd_at_34g2000hsf.googlegroups.com:
>
> 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.

Tim

-- 
tcross (at) rapttech dot com dot au