From DBarbour@austin.isd.tenet.edu Tue, 28 Aug 2001 07:17:13 -0700 From: DBarbour@austin.isd.tenet.edu Date: Tue, 28 Aug 2001 07:17:13 -0700 Subject: RE: ORA-10027 in ps/sql block Message-ID: MIME-Version: 1.0 Content-Type: text/plain Check the loop exit. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Thomas, Kevin" anais.com> cc: Sent by: Subject: RE: ORA-10027 in ps/sql block root@fatcity.com 08/28/2001 03:16 AM Please respond to ORACLE-L What does the code look like? -----Original Message----- Sent: 27 August 2001 18:56 To: Multiple recipients of list ORACLE-L I have a developer here who is trying to populate a cursor. Every time he runs his code he gets the above error stating that the buffer is too small. We have tried explicitly setting the buffer to 1,000,000 bytes. This is FAR greater than needed for the amount of data requested. No matter what buffer size we set he still gets the overflow. We have tried both of the following ideas from metalink Any ideas? Rodd Holman Doc ID: Note:1005230.6 Content Type: TEXT/PLAIN 26-AUG-1994 Type: PROBLEM Last Revision Date: 13-JAN-1995 Status: PUBLISHED Problem Description: ==================== Problem Explanation: ==================== NEW PROBLEM Solution: INCREASE THE SIZE OF THE BUFFER Solution Description: ===================== Increase the size of the buffer. The size of the buffer must be an integer between 2,000 and 1,000,000. Solution Explanation: ===================== Use one of the following two methods to increase the size of the buffer: 1. At the SQL*PLUS or SQL*DBA prompt, type SET SERVEROUTPUT ON SIZE n where n is an integer between 2,000 and 1,000,000. Example: To increase the buffer size to 10,000 type SET SERVEROUTPUT ON SIZE 10000 2. Inside the PL/SQL block type DBMS_OUTPUT.ENABLE(n) where n is an integer between 2,000 and 1,000,000. See Appendix A of the Oracle7 Server Application Developer's Guide for an explanation of the ENABLE command. . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: rodney.holman@lodgenet.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: Kevin.Thomas@calanais.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: DBarbour@austin.isd.tenet.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).