Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer Script Output Not Displaying Consistently

user1.0Jun 25 2019 — edited Jul 16 2019

Version 19.1.0.094

I've noticed that sometimes when I run a script from sql developer, the script output is not displayed consistently.

Sometimes, the output works beautifully.

Other times, some of the output is displayed.

Other times no output is displayed.

Typically the day starts out ok, and then this problem gets worse as the day goes on.

I've tried clearing the history.

I tried creating a startup script to set the serveroutput on as suggested in another post.

The length of the script doesn't seem to matter. 2-100 lines gets no output at times.

Is there a limit to the output displayed? Or a cache that needs to be cleared?

Here's an example of what it looks like partially displayed...the last line in the script is a commit but as you can see, that isn't displayed.

pastedImage_3.png

I opened a new window and tried the same script and this time I get no output at all displayed:

pastedImage_5.png

Comments
Post Details
Added on Jun 25 2019
5 comments
3,342 views