Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Forms 12.2.1.4 or 12.2.1.3 againts Oracle 19.7 - compile Packages

FCHJul 27 2020 — edited Sep 24 2020

Mike,

I am not sure if this bug is covered by BUG 25822726 (for Forms 14.0.2)

The case is easily reproduced:

Create a simple test form with this code

==============================

  WHEN-NEW-FORM_INSTANCE_TRIGGER:

     my_compile_test.version1(1);

     my_compile_test.version2(1);

 

Create a simple package with a private procedure (version2 in comments):

====================

CREATE OR REPLACE

PACKAGE profi.my_compile_test

is

  procedure version1 (a in number);

  --procedure version2 (a in number);

end;

/

CREATE OR REPLACE

PACKAGE BODY profi.my_compile_test

is

  procedure version1 (a in number)

  is

  begin

   null;

  end;

  procedure version2 (a in number)

  is

  begin

   null;

  end;

begin

null;

end;

/

In the Module do a compile. You get the error 302 (component version2 is not known) - correct!

Then remove the comments in the database package from version2 in the Package Specification. Recompile the module  - the module crashes.

Open the Module again:

The error 302 (component not known) remains.

Only workaround is flush the database or restart the database.

Can you reproduce this? Our develpment team is not able to work with a bug like this againts DB 19.7

Frank

This post has been answered by FCH on Sep 7 2020
Jump to Answer
Comments
Post Details
Added on Jul 27 2020
23 comments
2,362 views