Buffer limit running procedure

652689 Apr 25, 2013 7:19 PM

I am having an issue with buffer limits when running procedures. If I set the output limit to unlimited in the Dbms Output tab, I can then open a worksheet and write a piece of sql to run the procedure and the output is spooled to the tab.

The problem is when I have the procedure open and choose the run option in that window (not the run script option from a worksheet) the limit (default: 20000) appears to come back as the output no longer spools to the Dbms Output tab, it now spools to a log file in the Messages tab.

Is there a way to increase the output limit on these logs so I can get debug behaviour along with an unlimited output spool? I can always run these procedures from a standalone script but it would be really nice to have the option to run it from the edit procedure window.

Thanks,
Daniel

1. Re: Buffer limit running procedure

Chandrakaanth Ramamurthy Apr 25, 2013 9:04 PM (in response to 652689)

Refer the below forum

SQL Developer 1.5.3: SIZE honored in SET SERVEROUTPUT ON SIZE <nbr> ?
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Buffer limit running procedure

Gary Graham-Oracle Apr 25, 2013 10:39 PM (in response to 652689)

Hi Daniel,

I haven't tried this myself so this is just a guess, but you might try playing with the following preference setting:

Tools -> Preferences -> Environment -> Log -> Maximum Log Lines and/or Save Logs to File

Hope this helps,
Gary
Like Show 0 Likes(0)

Actions
3. Re: Buffer limit running procedure

652689 Apr 26, 2013 11:26 AM (in response to Chandrakaanth Ramamurthy)

This works, but I have to put this in to the run window myself, I was hoping for a setting that would stick. I will mark this helpful for now as it now allows me to do what I needed to do. I will upgrade it to correct if I don't get a better solution within a few days.

Thanks,
Daniel
Like Show 0 Likes(0)

Actions
4. Re: Buffer limit running procedure

652689 Apr 26, 2013 11:28 AM (in response to Gary Graham-Oracle)

Thanks for the suggestion Gary. I have tried this already and it had no effect.
Like Show 0 Likes(0)

Actions

Go to original post