This discussion is archived
7 Replies Latest reply: Aug 20, 2012 7:52 AM by Gunther Vermeir, Oracle RSS

Invalid package after conversion - spec merged with body

user627529 Newbie
Currently Being Moderated
Dear all,
I'm converting a db from 10.2 (WE8ISO8859P1) to 11.2.0.3 (AL32UTF8).

As the real data inserted in the original DB is WE8MSWIN1252 encoded, I took this steps:

1) created destination db 11.2.0.3 in WE8ISO8859P1 charset
2) expdp/imdp the database from sorg (10gR2) to dest (11gR2)
3) prepared the db for conversion: at this point there are NO invalid objects
4) DMU - converted the db from WE8ISO8859P1 to AL32UTF8, assuming WE8MSWIN1252 encoded data
5) at the end I have some packages which specification is merged with body.

The body for example looks like

create or replace
PACKAGE                           "mypackage" is
+.....+
end mypackage;



CREATE OR REPLACE PACKAGE BODY "mypackage" is
+....+
end mypackage;



instead of

create or replace
PACKAGE                           "mypackage" is
+.....+
end mypackage;


which of course invalidates the package.

Any ideas other than modify the package manually ?
Developers says me that all these packages are created with PLSQL developer, and gives no error.
I searched on MOS, google'd but can't find anything...

Regards,
Roberto

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points