help with restriction on dbms_output.put_line of 255??

From: Chris Eastwood <c.undieseastwood_at_gu.edu.au>
Date: Wed, 09 Jun 1999 03:13:25 GMT
Message-ID: <7jkm4v$kp6$1_at_kraken.itc.gu.edu.au>

HiYa

In WOW there is a print procedure (see bottom) that does a dbms_output.put_line that seems to have a limmit of 255 bytes. I know that I can use longer amounts than this in dbms_output.put_line as I have in the past, normally I have the LINESIZE set to something like 400 for longer lines that I am generating.

My question is; where is this linesize defaulting to 255 in the code? I have looked through WOW and haven't found this. I am calling this from a package
(that also doesn't set the linesize) that is then called from with in the CGI.

---

procedure print (cbuf in varchar2) is
-- -20000, ORU-10027: buffer overflow, limit of <buf_limit> bytes. -- -20000, ORU-10028: line length overflow, limit of 255 bytes per line.

      dbms_output_error exception;
      pragma exception_init(dbms_output_error,-20000);
begin
      dbms_output.put_line(cbuf);
exception
      when dbms_output_error then
          if substr(sqlerrm,12,9) = 'ORU-10027' then
               if bufSize < 1000000 then
                    bufSize := bufSize + 100000;
                    dbms_output.enable(bufSize);
                    if dbg then
                        print('***Handled exception ORU-10027***');
                    end if;
                    print(cbuf);
               else
                    -- OK, give up - exceeded max buffer size
                        raise;
               end if;
          elsif substr(sqlerrm,12,9) = 'ORU-10028' then
               if length(cbuf) > 0 then
                    print(substr(cbuf,1,255));
                    if dbg then
                        print('***Handled exception ORU-10028***');
                    end if;
                    print(substr(cbuf,255));
               end if;
          end if;

end;

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer email ua.ude.ug.xobliam_at_doowtsae.c Motorcyclist and dingbat

please remove undies for reply

---

Ohhh ... you work all day, slave over a hot stove all night  yet you *still* have time for sadomasochism ... how do you do it? A little man hurts me.
<ding>

    Oh Mister Mean ... Oh Mister Mean
    15 Minutes with him and you'll be blue and green     Studded belts and leather whips
    Bondage trousers on his hips
    Wack and punish as you dust with Mister Mean   Ohhhh he whips me around the house in minutes ... lets get cracking ... Received on Wed Jun 09 1999 - 05:13:25 CEST