Re: dbms_output (buffer overflow)

Chrysalis wrote:
`
` Rami Juhela wrote:
` >
` > Is there any way to prevent buffer overflow when using
` > dbms_output.put_line in PL/SQL -cursor loop? (Oracle7).
` >
`
` I presume you are executing your PL/SQL from SQL*Plus.
` So you need to specify SET SERVEROUT[PUT] ON SIZE nnnnn
` (Note that the ON is required, even if it is already on!)
`

Or you can use

DBMS_OUTPUT.ENABLE(100000); at the start of your script, which does the same thing ?

Nick.

-- 
+--------------====================------------------------+
| Nick Clark.  ####################   NickC_at_dial.pipex.com |
+--------------====================------------------------+