# DBMS\_OUTPUT "lost"

**URL:** <https://forums.toadworld.com/t/dbms-output-lost/38249>\
**Category:** SQL Navigator\
**Created:** [August 26, 2016, 2:47am UTC](https://forums.toadworld.com/t/dbms-output-lost/38249 "2016-08-26T02:47:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [August 26, 2016, 2:47am UTC](https://forums.toadworld.com/t/dbms-output-lost/38249/1 "2016-08-26T02:47:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\
**Post date:** [August 28, 2016, 8:30pm UTC](https://forums.toadworld.com/t/dbms-output-lost/38249/2 "2016-08-28T20:30:10Z")

</div>

Hi Martin,

Did you get any luck to reproduce steps?

Michael

---

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [August 28, 2016, 11:04pm UTC](https://forums.toadworld.com/t/dbms-output-lost/38249/3 "2016-08-28T23:04:52Z")

</div>

Hi Michael

Not yet, had a little holiday 😉

Regards

Martin

---

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [August 29, 2016, 1:11am UTC](https://forums.toadworld.com/t/dbms-output-lost/38249/4 "2016-08-29T01:11:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\
**Post date:** [August 29, 2016, 1:37am UTC](https://forums.toadworld.com/t/dbms-output-lost/38249/5 "2016-08-29T01:37:45Z")

</div>

Thank you Martin,

we will try to look into this.

---

<div class="post-metadata">

**Author:** ![martin\_goblet](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/martin_goblet/32/267_2.png) [@martin\_goblet](https://forums.toadworld.com/u/martin_goblet)\
**Post date:** [September 5, 2016, 1:46am UTC](https://forums.toadworld.com/t/dbms-output-lost/38249/6 "2016-09-05T01:46:15Z")

</div>

Hi Mickael

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

Regards

Martin