Seeing Stored Procedure Output in Toad

Add a line like the following to your stored procedure or function:

dbms_output.put_line('test');

Now enable the dbms output tab in your SQL editor window:

1. right click beside the output tab at the bottom of the sql editor
2. check sql editor desktop>dbms output
3. Click the red button in the left of the dbms output tab so that it turns green
4. Use the eraser button to clear the ouput (otherwise it gets appended each time there is output)
5. You may need to set the buffer size to be greater than the default 20,000 if your code churns out a lot of debug information. You will get an error from Toad about a buffer overflow.