Re: DBMS_PIPE

Mick wrote:
>
> Does anyone know how to increase the size of the BUFFER used with
> DBMS_PIPE and what is the maximum size?
>
> Thanks if you can help.

Try

SQL> desc DBMS_PIPE

Many of the procedures take the max buffer size as a parameter

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."