Reconnect in a test window - 09/10/20 10:03 AM
Hi all,
Seeking any tips, here.
I often find I have to disconnect and reconnect my test window because the session state of the package I'm working on has been invalidated and therefore I need a new database session. Sometimes there's an additional complication where several packages are involved in the process and this means more often I have to reconnect. Often a debug session will work, but as often it fails to find a dependent package that has its session state invalidated, so even debugging doesn't help.
I was wondering if there was a quicker way to get a new database session as this same user and then run the test, rather than navigating to the test window tab, disconnect, reconnect and then execute the test.
Any ideas?
Thanks,
Tim
PS: I've tried adding "EXECUTE IMMEDIATE" to the test script in order recompile the packages, but that doesn't always resolve it ;-(.
Seeking any tips, here.
I often find I have to disconnect and reconnect my test window because the session state of the package I'm working on has been invalidated and therefore I need a new database session. Sometimes there's an additional complication where several packages are involved in the process and this means more often I have to reconnect. Often a debug session will work, but as often it fails to find a dependent package that has its session state invalidated, so even debugging doesn't help.
I was wondering if there was a quicker way to get a new database session as this same user and then run the test, rather than navigating to the test window tab, disconnect, reconnect and then execute the test.
Any ideas?
Thanks,
Tim
PS: I've tried adding "EXECUTE IMMEDIATE" to the test script in order recompile the packages, but that doesn't always resolve it ;-(.