Re: dbms_output from dbms_jobs procedures >> DAMORGAN: did you post something about a leak?

From: Jimbo1 <nightfanguk_at_yahoo.co.uk>
Date: 15 Dec 2005 08:18:01 -0800
Message-ID: <1134663481.359971.225110@o13g2000cwo.googlegroups.com>

Hello again,

Try applying this script to your current situation. It will only work if you wrap the PL/SQL containing the calls to DBMS_OUTPUT.PUT_LINE, and execute in the same session though, and you'll only get the output once the PL/SQL procedure has finished.

I don't think you're heading in the right direction with this, but I'll be happy to be proved wrong.

Cheers.

James

SET SERVEROUTPUT ON DECLARE
   tb_lines DBMS_OUTPUT.CHARARR;
   ln_no_lines INTEGER := 200;

   PROCEDURE fill_buffer
   IS
   BEGIN
      DBMS_OUTPUT.ENABLE(100000);

      FOR i IN 1..100
      LOOP
         DBMS_OUTPUT.PUT_LINE('The current iterator is: '||i);
      END LOOP;

   END fill_buffer;

BEGIN
   fill_buffer;

   DBMS_OUTPUT.GET_LINES(tb_lines, ln_no_lines);    DBMS_OUTPUT.PUT_LINE('No. of Lines returned '||ln_no_lines);

   FOR i IN tb_lines.FIRST..tb_lines.LAST    LOOP
      DBMS_OUTPUT.PUT_LINE('Line is: '||tb_lines(i));    END LOOP;
END;
/ Received on Thu Dec 15 2005 - 10:18:01 CST