Re: Print a procedure text.

When all else fails with that error message,

    set arraysize 1

MAXDATA is measured in bytes, by the way, and you want it large. The max value is something like 64K I think - but I also think the max may be the default anyway.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

SG wrote in message <3C225B06.82C0CD3C_at_ca.ml.com>...


>  Hi,

>I tried, but have the error: "buffer overflow. Use SET command to reduce

>ARRAYSIZE or increase MAXDATA".

>I tried to SET MAXDATA 1000, but it does not help.

>How can I fix this problem?

>