I have imported dump of oracle 10 version with tables, procedures and packages to oracle 11g version.
While am not facing any issues with tables and procedures, certain body of packages compiles with error.
On checking the same packages in old oracle version, i ve noticed that the reference status of package body is VALID. But in 11g version, it is INVALID
Also there is a mismatch in dependencies of package from old version and new version.
Cud someone shed light on what am i missing?
I wana compile the procedure without any error in 11g version!