Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-10027 in ps/sql block

RE: ORA-10027 in ps/sql block

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Tue, 28 Aug 2001 07:17:13 -0700
Message-ID: <F001.003799BD.20010828072600@fatcity.com>

Check the loop exit.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                          
                    "Thomas, Kevin"                                                    
                          
                    <Kevin.Thomas_at_cal       To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>  
                    anais.com>              cc:                                        
                          
                    Sent by:                Subject:     RE: ORA-10027 in ps/sql block 
                          
                    root_at_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_at_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_at_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_at_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_at_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_at_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_at_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). Received on Tue Aug 28 2001 - 09:17:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US