Sql & Test Window

[Relogin]

1. We compile a package with procedure "A" with commit in the end of procedure "A"
2. We start on execution a code - a call "A" in SQl Window
3. We receive a mistake in SQL Window ORA-04068. Commit it is not executed is correctly. It is made implicit Rollback.
4. We compile a package with procedure "A" with commit in the end of procedure "A"
5. We start on execution a code - a call "A" in Test Window.
6. We receive the information on a mistake in statusbar about ORA-04068. Commit it is executed! It is incorrect, since there was mistake ORA-04068! Why?

 

[Marco Kalter]

The Test Window will see the "ORA-04068: Existing state of packages has been discarded" error, and will re-execute with the initial state. This makes it easier to perform edit/compile/test cycles.

The SQL Window will not do this.