Test Manager & Test Window

romtax

Member
Hello.
I use the Test Manager in the PL/SQL Developer v8.0.4.1514. Can you please tell the answers to my questions:
1) Can I use 2 or more independent PL/SQL-block in a test window, for example, to reset the values ​​of package variables? Example:
begin
dbms_session.reset_package;
end;

begin
my_package.my_procedure ();
end;

2) Can I organize a list of tests in the Test Manager window in a tree, like the object browser?
 
1. No, but you can place multiple calls in one Test Window. The reset_package example will probably not work though, because I don't think you can reset the package state and continue to execute. On the other hand it is not necessary to reset the package state, because all Test Scripts executed from withing the Test Manager will run with a new session.

2. No, this is currently not possible.
 
Marco Kalter said:
1. ...all Test Scripts executed from withing the Test Manager will run with a new session.
No, unfortunately all the scripts are executed in-one and the same session. As a result, is not possible change the value of package variables in the test script. And if the script requires different values ​​of package variables, then I have to add additional scripts to initialize package variables and return to its original state (respectively, the number of scripts increases significantly), to the same need to make sure that they are executed in the correct order.
Marco Kalter said:
2. No, this is currently not possible
Very sorry. Thank you.
 
Back
Top