dbms_output.put_line - Handling ORU-10027 exceptions

From: Jim <lermontovb_at_hotmail.com>
Date: Thu, 29 Jul 1999 00:35:15 +0100
Message-ID: <7no4jc$po1$1@lure.pipex.net>

Does anyone know if it's possible to catch one of these buffer overflow errors with an exception handler?

I've tried the following but nothing in the exception handler seems to be executed.

set serveroutput on size 2000

declare
  v_Long_String Varchar2(30) := 'abcdefghijklmnopqrst';   e_buffer exception;
  pragma exception_init(e_buffer, -10027); -- params might be the wrong way round - it was a long day
begin

   for iCount in 1..300 loop

        begin
            dbms_output.put_line(v_Long_string);
        exception
            when e_buffer then
                   null;              -- or whatever
            when others then
                   null;              -- or whatever
        end;

  end loop;
end; Received on Wed Jul 28 1999 - 18:35:15 CDT