When the following objects are in the database, there are problems generating tests for the package:
'creating a test for qcto_package.prc2 is not possible because it results in an invalid generated test package PLS-00313: 'q_QCTO_TYPE1' not declared in this scope'
Steps to replicate:
Create the following package in SCOTT schema
create or replace type qcto_type1 as object( at1 number );
create or replace type qcto_type3 as object( at1 number, at2 qcto_type1 );
create or replace type qcto_type4 as object( at1 qcto_type1, at2 qcto_type3 );
create or replace package qcto_package
as
procedure prc2( p1 out qcto_type4 );
end;
/
create or replace package body qcto_package
as
procedure prc2( p1 out qcto_type4 ) is begin null; end;
end;
/
Grant the following to another schema
grant execute on qcto_type1 to user;
grant execute on qcto_type3 to user;
grant execute on qcto_type4 to user;
grant execute on qcto_package to user;
Create a test case under USER for the package qcto_package and create a Test Case for the procedure PRC2 and run it.
It generates an invalid compilation because it can't see the object qcto_type1 even though it has been granted the correct privileges
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Code Tester for Oracle. Should be addressed in the v2.6 release
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center