Oracle-L: RE: PROCEDURE ERROR

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 07 May 2002 16:48:46 -0800
Message-ID: <F001.0045AE1B.20020507164846@fatcity.com>

Do you have dbms_output somewhere in the code?

-----Original Message-----
Sent: Tuesday, May 07, 2002 8:19 PM
To: Multiple recipients of list ORACLE-L

Hi Group,

Could someone PLEASE tell me why I keep getting the error (and possible

solution):
ORA-20000:
ORU-10027: buffer overflow, limit of 2000 bytes

It did insert 2 records before it blew up.

This is the little bugger:

g_statement_txt VARCHAR2(2500);

WHILE g_loop_cnt < 22 LOOP

       g_statement_txt :=  ' INSERT INTO dibbs_zone_price ' ||
             '  (upc, zone, curr_price,future_price, eff_date) ' ||
         ' SELECT rih_unit_upc_1 ' || ', ' || 
                        g_loop_cnt || ',' ||
                        ' rih_cdc_curr_price_' || g_loop_cnt || ',' ||
                        ' rih_cdc_fut_price_' || g_loop_cnt || ',' ||
                        ' rih_cdc_eff_date_' || g_loop_cnt ||
                '  FROM YDREGCMFHDR_RGA ' ||
                 '  WHERE rih_unit_upc_1 = ' || '''' || '075919000050' ||
'''';
             EXECUTE IMMEDIATE g_statement_txt;
        IF g_loop_cnt = 9
          THEN
             g_loop_cnt := g_loop_cnt + 6;
         ELSIF g_loop_cnt = 17
             THEN
             g_loop_cnt := g_loop_cnt + 3;
          ELSE
            g_loop_cnt := g_loop_cnt + 1;
         END IF;

END LOOP; THANK YOU, THANK YOU !!!! Al Rusnak
804-734-8453
rusnakga_at_hqlee.deca.mil

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rusnak, George A.
INET: rusnakga_at_hqlee.deca.mil

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: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------