Message Error: buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA. |
Cause of Error This behavior occurs because the value defined for the ARRAYSIZE variable is too large or the value defined for the MAXDATA variable is too small to process the SELECT statement you tried to execute. |
Solution Summary Set the ARRAYSIZE or the MAXDATA variable to a value that allows the processing of the SELECT statement, and then run the statement again. |
Solution Details 1) Determine the appropriate values for the ARRAYSIZE and the MAXDATA variables: a) For each column of data that you want to retrieve in the SELECT statement, calculate the minimum row width needed by using the following formula: where  NOTE: For numeric columns, add an additional 40 percent to the derived row width. You can count the maximum number of characters that can be displayed in the query result for a column by counting the number of dashes under the column heading in the output.b) Add the row widths for all the columns you want to retrieve. The total is the minimum value that you need to set for the MAXDATA variable for your query to return a result. 2) If you have not already done so, start SQL*Plus 8.0, and then log on to the appropriate database. 3) Adjust either the ARRAYSIZE variable, the MAXDATA variable, or both by doing one or both of the following: a) At the SQL*Plus prompt, type the following command, and then press ENTER: SET ARRAYSIZE where b) At the SQL*Plus prompt, type the following command, and then press ENTER: SET MAXDATA where 4) Run your SELECT statement again. |
Applies to Software Version Oracle8 |
Error: buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA.
