Test Window (v8) - variable settings ignored

[lparker]

I have a set of PL/SQL calls that has some input parameters, that I am calling through the Test Window.
1. Set parameter to value 1
2. Execute PL/SQL by pressing Execute (F8).
3. Data returned as expected.
4. Change parameter to value 2
5. Execute PL/SQL by pressing Execute (F8).
6. Data returned but not as expected. Data returned is for the last parameter value of 1. It did not recognise that I had changed the value from 1 to 2.
7. Disconnect and reconnect.
8. Run PL/SQL again by pressing Execute (F8).
9. Data returned as expected for value 2.
10. Change parameter to value 3.
11. Execute PL/SQL by pressing Start Deugger. Run to completion.
12. Data returned as expected for value 3.

This can cause lots of issues if we need to change the values of parameters and rerun without reconnecting or debugging.

Thanks
Lise

 

[Marco Kalter]

That would be a remarkable issue. Can you send me a test procedure to reproduce this?

 

[lparker]

I am sorry - we held some variables within the session that caused the new parameter settings to not being used.
Debugging through it will create a new session and hence any package variables will be lost.