PROCEDURE ERROR

From: Rusnak, George A. <rusnakga_at_hqlee.deca.mil>
Date: Tue, 07 May 2002 16:18:58 -0800
Message-ID: <F001.0045ADC9.20020507161858@fatcity.com>

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).

Received on Tue May 07 2002 - 19:18:58 CDT