|
Wishlist: Test Window
|
Joined: Jul 2003
Posts: 1,140 Virginia, USA
Member
|
OP
Member
Joined: Jul 2003
Posts: 1,140 Virginia, USA |
I was reading on AskTom.Oracle.com about 'existing state of package blah, blah, blah' yesterday and heard about DBMS_SESSION.RESET_PACKAGE.
I would like a check box on the toolbar of the test window that says something like 'Reset package states before execution' and if checked PLSD would issue that command before running the contents of the test window.
Scott Mattes
|
|
|
Re: Wishlist: Test Window
|
Joined: Aug 1999
Posts: 22,206
Member
|
Member
Joined: Aug 1999
Posts: 22,206 |
The Test Window will automatically rerun the Test Script when it first fails with "ORA-04068: Existing state of packages has been discarded". A warning will be displayed on the status line, because all global package variables will have been reset.
Marco Kalter Allround Automations
|
|
|
Re: Wishlist: Test Window
|
Joined: Jul 2003
Posts: 1,140 Virginia, USA
Member
|
OP
Member
Joined: Jul 2003
Posts: 1,140 Virginia, USA |
Hmmm, I wonder why I let this drop.
Anyway, the reason for this request is for test repeatability. I'd like to be able to run the same test over and over and over again and always get the same results. If the package being tested sets any persistent values they sometimes need to be reset in order to repeat the test.
Scott Mattes
|
|
|
Re: Wishlist: Test Window
|
Joined: Aug 1999
Posts: 22,206
Member
|
Member
Joined: Aug 1999
Posts: 22,206 |
I have added this to the list of enhancement requests. Note that you can also call dbms_session.reset_package in the Test Script.
Marco Kalter Allround Automations
|
|
|
Re: Wishlist: Test Window
|
Joined: Jul 2003
Posts: 1,140 Virginia, USA
Member
|
OP
Member
Joined: Jul 2003
Posts: 1,140 Virginia, USA |
Scott Mattes
|
|
|
Re: Wishlist: Test Window
|
Joined: Dec 2005
Posts: 2,004 Roima Denmark
Member
|
Member
Joined: Dec 2005
Posts: 2,004 Roima Denmark |
Hello Scott.
I always reconnect to my user to make sure that package variables are flushed.
|
|
|
Re: Wishlist: Test Window
|
Joined: Feb 2006
Posts: 14 Plano, Texas USA
Member
|
Member
Joined: Feb 2006
Posts: 14 Plano, Texas USA |
Scott's request is a great one, I completely second him on the value of such a feature in a future release.
|
|
|
|
|
|