Re: Buffers problems!! ... (Hekp!!!)

jkyf0131_at_hotmail.com (JK Yao) wrote in message news:<93f65984.0109032124.3124ed26_at_posting.google.com>...
> dear all,
>
> I build a order report with including some packages in Oracle8.1.6. I
> got following error messages.
>
> SQL> @ C:\WINDOWS\Desktop\C_InvStockAge.rdf
> Creating MMI_INV_STOCK_AGE_RPI specification
> &#27794;&#26377;&#20219;&#20309;&#37679;&#35492; (No Error)
> Creating report view C_INVSTCKAGE_REP
> Creating MMI_INV_STOCK_AGE_RPI implementation
>
> &#35686;&#21578;&#65306;&#25152;&#24314;&#31435;&#30340;&#21253;&#35065;&#31243;&#24335;&#20027;&#39636;&#21547;&#26377;&#32232;&#35695;&#37679;&#35492;
> (Warning: package has compile error)
>
> &#32233;&#34909;&#21312;&#30332;&#29983;&#19978;&#38480;&#28322;&#20301;.
> &#35531;&#29992; SET &#21629;&#20196;&#28187;&#23569; ARRAYSIZE
> &#25110;&#22686;&#21152; MAXDATA
> (buffers ..., please use SET command decrese ARRAYSIZE or increase
> MAXDATA)
> &#27794;&#26377;&#20219;&#20309;&#37679;&#35492;
> (no error)
>
>
> -------------------
> There are some Chinese characters, so I translate in English. Anyone
> knows any problem related to ARRAYSIZE and MAXDATA? How to change it
> and what number should I give?
>
> Please help!!!!
> Thanks a lot.
>
> regards,
> JK

Please refer to your sql*plus manual for a description of set arraysize and set maxdata.
IIRC, arraysize * maxdata can not exceed 64k. Please try to resolve your questions by using the Oracle provided documentation before you start posting. In this particular case referring to your manual probably takes less time than posting.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 04 2001 - 05:03:53 CDT