# dbms\_output on/off

**URL:** <https://forums.toadworld.com/t/dbms-output-on-off/33277>\
**Category:** Toad for Oracle - Beta\
**Created:** [May 12, 2015, 12:37pm UTC](https://forums.toadworld.com/t/dbms-output-on-off/33277 "2015-05-12T12:37:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![phyllis.helton\_1150](https://avatars.discourse-cdn.com/v4/letter/p/ac8455/32.png) [@phyllis.helton\_1150](https://forums.toadworld.com/u/phyllis.helton_1150)\
**Post date:** [May 12, 2015, 12:37pm UTC](https://forums.toadworld.com/t/dbms-output-on-off/33277/1 "2015-05-12T12:37:36Z")

</div>

This is not necessarily a new problem, but I figured I should report it again in case it can be fixed. 🙂

If I am running pl/sql that has dbms\_output that I want to look at, it runs fine. If I then make changes to the underlying package and re-run the pl/sql in the same window, I get the “existing state of packages error”. Then if I re-run the pl/sql, leaving the dbms\_output toggled on, I do not get output. The only way to get output once I’ve gotten the “existing state of packages” error is to turn the output off and then back on again before I run my code.

It would be great if this was not the case, especially because I have been known to forget to turn it back on.

Blessings,

Phyllis

–  
**Phyllis Helton**

Data Magician  
Digital Strategies, Cru | Data Sciences & Analytics  
Office ☎ 407-515-4452

[phyllis.helton@cru.org](mailto:phyllis.helton@cru.org)  
 ![](http://emailassets.cru.org/cdn-crumail/cru.png)

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [May 16, 2015, 9:07pm UTC](https://forums.toadworld.com/t/dbms-output-on-off/33277/2 "2015-05-16T21:07:55Z")

</div>

Hi,

I think you can test this in SQL\*Plus and you’ll get the same resut.

Problem is package state (invalidation)…but please test. If this is persistent in core Oracle tools, then Toad has nothing with it.

😉
