Re: SET SERVEROUTPUT ON; DBMS_OUTPUT..

s.zwischenbrugger_at_magnet.at (Stefan Zwischenbrugger) wrote:
>If you want to see the result of dbms_output.put_line('bla bla')
>you have to SET SERVEROUTPUT ON first.
>In Oracle Application you can call a stored procedure directly without
>calling PL*SQL first.
>I cannot see my dbms_output.put_line(..) output. How can I persuade
>Oracle to show me the result.
>
>regards,
>
>Stefan
Try adding the line:

     dbms_output.enable(1000000);
BEFORE you call dbms_output.put_line.

-- 
========================================================================
  Bob Manieri                           email : bmanieri_at_ford.com
  Database Administrator                voice : (610) 584-7085
  Ford Electronics, Lansdale, PA        pager : (609) 342-0314
========================================================================
  Business is war....information is the high ground.  - J.Abrahamson
  ...we can deprive the enemy of the high ground.  - J. Buford
========================================================================