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!

  • Are these your own packages? Are all the package specs valid? Do you have the same number of package specs? – Colin 't Hart Apr 7 '15 at 15:02
  • @Colin'tHart All are my own packages and yep they are valid, as am able to compile and run them in 10.x version. The issue is raised while trying to transfer packages from 10.x version to 11g, using impdp and expdp commands – Highbrow Apr 8 '15 at 5:01
  • You didn't answer all my questions: are all the specs valid in the 11g database? Do you have the same number of specs in the 11g database -- ie did all packages come across? – Colin 't Hart Apr 8 '15 at 6:14
  • When you compile the package(s) in 11g, what error(s) do you get? – Phil Sumner Apr 8 '15 at 13:00
  • @Colin'tHart sorry..yep all the packages have came across..The discrepancies were only in References of the imported packages – Highbrow Apr 8 '15 at 13:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.