DBMS_OUTPUT "lost"

SQL Navigator
1

Hello

SQL Nav 7.3 32 bit, Win 7 pro 64 bit

Today I lost a few times the DBMS_OUTPUT in the Output Widow. The server output was open, but no display. Turning it OFF/ON doesn’t solve the problem. When I recompile the procedure, then the outputs appears again.

The only thing I’ve done is to modify other procedures between the run that displayed the output and the ones that did not display the outputs.

Regards

Martin

2

Hi Martin,

Did you get any luck to reproduce steps?

Michael

3

Hi Michael

Not yet, had a little holiday :wink:

Regards

Martin

4

Hi Michael

Same problem just came up again. I’m working in a package and "debugging " my new procedure.

All I do is correct my procedure, launch it again and verify the results with a secondary SQL statement.

It happend after 2 errors (the first one may be the one to look at) :

09:45:41 ORA-04068: existing state of packages has been discarded

09:46:16 ORA-01722: invalid number

Regards

Martin

5

Thank you Martin,

we will try to look into this.

6

Hi Mickael

Got it again after : ORA-04068: existing state of packages has been discarded

Regards

Martin