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
Hi Martin,
Did you get any luck to reproduce steps?
Michael
Hi Michael
Not yet, had a little holiday 
Regards
Martin
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
Thank you Martin,
we will try to look into this.
Hi Mickael
Got it again after : ORA-04068: existing state of packages has been discarded
Regards
Martin