Limiting the Display Width in Oracle

HI there everyone,

     I have a slight prblem that I am hoping someone here can answer. When writing a customized PL/SQL function, I am unable to run it although it compiles properly. The problem is when I go to run it, I get the following error:

"buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA."

The dilemma is that the function isn't returning that many characters when the function is run. Instead, I think the display width may be overflowing the buffer when I run the function, because the dashes that are usually displayed under the column names extend past the width of the screen. Can anyone tell me how to limit the display width (i.e. the number of dashes outputted to the screen)?!?

Thank you in Advance

--
Michael Received on Thu Jul 23 1998 - 16:02:09 CDT