Output Goes Away

[chanatuke]

When we (re)compile a package, the next time we run SQL in that window, the Output window does not generate output. We need to close windows, open new ones, run SQL in order to get output to generate again.

Is there a way around this?

 

[Marco Kalter]

Do you get an "ORA-04068: Existing state of packages has been discarded" warning? This seems to discard the dbms_output package state as well, and the result is that there is no output. We'll try to fix this for the 5.1.4 patch release.

------------------
Marco Kalter
Allround Automations

 

[chanatuke]

No, we do not get an ORA error of any kind. If we Clear the output, then uncheck and then check the Show Output box, this seems to work though. Its a bit tedious is all, and sometimes I don't remember to do it.

 

[Marco Kalter]

It is not an error. It is a subtle warning that is displayed on the status line between parenthesis after execution. Can you check again?

------------------
Marco Kalter
Allround Automations

 

[Martin Plangger]

Use DBMS_SESSION.RESET_PACKAGE to revert all packages to their
uninitialised state and hence destroy the contents of package variables.
Running RESET_PACKAGE reverts to the situation at the beginning of a
session.
In the session that receives the ORA-4068 ORA-6508 error messages,
prior to calling the failing package.procedure, execute RESET_PACKAGE:

------------------
Martin

 

[ScottMattes]

Yesterday, while working on a package, I noticed that after compiling the package and clicking the main toolbar execute button the test window would go 'busy' for about a minute and then give the error about the existing state, yada, yada. Click the button again and it would go 'busy' for another minute and end as it should and my output was there.
I then tried compiling and then using the execute button in the test window and then the run button and did not get the error.
I see no real use to this behavior, was it intentional and if so, what is the benefit to it working this way?

------------------
------------
Scott Mattes

 

[Marco Kalter]

The disappearance of the output after an ORA-04068 warning is fixed in the upcoming 5.1.4 release.

------------------
Marco Kalter
Allround Automations