Tuesday, 2 September 2008

DBMS_OUTPUT from multiple worksheets

While I'm talking today, heres another feature people have been asking for. Separated DBMS_OUTPUT from the main worksheet.

This way you can now have several worksheets on the same connection pumping out anything onto dbms_output and it appears nicely in the dockable window. You can still specify it inline in the code with
set serveroutput on
and it will appear in the script output window as an alternative.


Byte64 said...

Hello Barry,
a while ago i posted an article about SQLDeveloper DBMS_OUTPUTS panes and pains ;-).

The article applied to version 1.2.1 but I suppose it still applies to 1.5.1, doesn't it?


Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.