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

Apart from what looks like a package error, try "set arraysize 10" or lower. Do a "show arraysize" to see what it's currently set at. Received on Tue Sep 04 2001 - 05:12:35 CDT