Major bug v10

[Benjamin L]

We found a major bug in v10.

Procedure collections.reproduce want to call the procedure debug_collection.reproduce_ora_error. This procedure has a param with type collections.tTab (from the calling package).

When we try to compile this in 10.0.2.1697 in a program window, we get PLS-00306 wrong number or types of arguments...

In v9 we can compile, also in a command window in v10 it works. Can you please fix this imemdiate. This bug extremly disturbs our development.

reproducing sources:

CREATE OR REPLACE PACKAGE debug_collection IS
PROCEDURE reproduce_ora_error(aTab IN collections.tTab);
END debug_collection;
/
CREATE OR REPLACE PACKAGE BODY debug_collection IS

PROCEDURE reproduce_ora_error(aTab IN collections.tTab) IS
BEGIN
NULL;
END;
END debug_collection;
/
CREATE OR REPLACE PACKAGE collections IS
TYPE tTab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
PROCEDURE reproduce;
END collections;
/
CREATE OR REPLACE PACKAGE BODY collections IS
PROCEDURE reproduce IS
lTab collections.tTab;
BEGIN
debug_collection.reproduce_ora_error(lTab);
END;
END collections;
/

regards Benjamin

 

[Marco Kalter]

I could reproduce this bug when the "Safe compilation" preference (Tools > Preferences > Program Window) is enabled. Can you disable it and try again?

 

[Benjamin L]

In my case, the problem exists whether "Safe compilation" is activated or not.

Edit: When the Package once is compiled in the database, and i deactivate the "Safe compilation" option, than i can compile it in a progaram window.
If it is a new package, than it dioesn't help to deactivate safe compilation.

 

[Marco Kalter]

Without safe compilation it should always work, unless of course you have a dependency where a referenced package specification does not yet exist or is invalid.

 

[Benjamin L]

Ok, i think we can life with the "safe compilation" option.
Indeed, we had different options for PSD 9 and 10.

Thank you