This discussion is archived
4 Replies Latest reply: Apr 26, 2013 4:28 AM by 652689 RSS

Buffer limit running procedure

652689 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points