Invalid Synonym on Database Package
I have recently modified a database package spec and package body for the first time since our upgrade to Oracle 10.2.0.4.0. Once I ran my code to modify the package spec and package body, the synonym became invalid. I've read that this is a new feature in Oracle 10g. I'm just wondering how I get the synonym valid again. I have tried recompiling the package spec and body again and I've also tried executing the package. The package executes fine, but the synonym still has a status of Invalid. If anyone can help I would greatly appreciate it!!
Shellie