7 Replies Latest reply: Aug 20, 2012 9:52 AM by "Gunther Vermeir, Oracle-Oracle" RSS

    Invalid package after conversion - spec merged with body

    user627529
      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