Re: Line Overflow Error. ORA-20000: ORU-10028

Hi,
check dbms_output.put_line, the max length is 255:

begin
dbms_output.put_line(lpad('x',256));
end;

rogerhernand_at_surfside.net wrote:

> Hello. Could you help me with the following problem?
>
> ORA-20000: ORU-10028: line length overflow, limit of 255 bytes
> per line
>
> This error appears when a stored procedure is being executed.
> The output
> if this procedure is listed below:
>
> Recalculated Total = bill_total_b4_tax + Tax + Other_energy_charge
>
>
> Recalculated Total 19592.19272
> Update ieo_rer_bill_dmnt set ieo_maxkw = 421
> Insert into ieo_rer_yearly_report Month = j1 = 1
> Before select From ieo_rer_bill_dmnt_ym K = 1
> select ieo_ttlkwh, ieo_maxkw into total_Kwh, temp_maxkw = 0
>
>
> Upd_str := Update ieo_rer_yearly_report Set Year1 = 0
> Upd_str := Update ieo_rer_yearly_report Set Year1 = 0 , kw_year1
> = 0
>
> Upd_str := Update ieo_rer_yearly_report Set Year1 = 0 , kw_year1
> = 0 Where
> ieo_cust_code =
> 62225 And ieo_styp_code = 'CELC' And ieo_vendor_code = '11248'
> And
> ieo_vendor_Acct_num =
> '3-63-69252-06534-00-9002-4-01'
> begin
> IEO_RER_PROCESS(62225,'CELC','11248','3-63-69252-06534-00-9002-4-01','A3a','1946');
>
> end;
>
> *
> ERROR at line 1:
> ORA-20000: ORU-10028: line length overflow, limit of 255 bytes
> per line
> ORA-06512: at "IEO.IEO_RER_PROCESS", line 754
> ORA-06512: at line 1
>
> IEO in IEOP>
>
> The code that is being executed is as follows:
>
> 683 Upd_str := 'Update ieo_rer_yearly_report Set
> Year'||to_char(k)||' = '||to_char(total_kwh);
> 684 dbms_output.put_line(' Upd_str := '||Upd_str);
> 685 Upd_str := upd_str||' , kw_year'||to_char(k)||'
> =
> '||to_char(temp_maxkw);
> 686 dbms_output.put_line(' Upd_str := '||Upd_str);
> 687 Upd_str := upd_str||' Where ieo_cust_code =
> '||to_char(cust_code)||' And ieo_styp_code = '''||styp_Code||'''';
> 688 Upd_str := upd_str||' And ieo_vendor_code =
> '''||vendor_Code||''''||' And ieo_vendor_Acct_num =
> '''||vendor_acct_num||'''';
> 689 dbms_output.put_line(' Upd_str := '||Upd_str);
> 690 Upd_str := upd_str||' And ieo_tariff_code =
> '''||tariff_Code||''''||' And ieo_meter_code = '''||meter_code||'''';
> 691 dbms_output.put_line(' Upd_str := '||Upd_str);
> 692 Upd_str := upd_str||' And ieo_month = '||to_char(j);
> 693 dbms_output.put_line(' Upd_str := '||Upd_str);
> 694 cid := dbms_sql.open_cursor;
> 695 dbms_output.put_line(' cid := '||to_char(cid));
> 696 dbms_sql.parse(cid, UPD_STR, dbms_sql.v7);
> 697 dbms_output.put_line(' call to dbms_sql.parse cid,
> UPD_STR,
> dbms_sql.v7 ');
> 698 rows_processed := dbms_sql.execute(cid);
> 699 dbms_output.put_line(' rows_processed :=
> '||to_char(rows_processed));
> 700 dbms_sql.close_cursor(cid);
>
> Lines 683, 684, 685, 686, 687, 688, and 689 are executed. The
> code fails
> at line 690 due to a line overflow.
>
> Notice that the the listed below also fails with the same error
> message:
>
> 705 Update ieo_rer_yearly_report set
> 706 year1 = total_kwh,
> 707 kw_year1 = temp_maxkw
> 708 where ieo_cust_code = cust_code
> 709 And ieo_styp_code = styp_Code
> 710 And ieo_vendor_code = vendor_Code
> 711 And ieo_vendor_Acct_num = vendor_acct_num
> 712 And ieo_tariff_code = tariff_Code
> 713 And ieo_meter_code = meter_code
> 714 And ieo_month = j1;
>
> Is there a parameter in init.ora that can be changed so that
> this error
> does not occur any more?.
>
> Thanks a lot,
>
> Roger Hernandez
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --
> Author:
> INET: rogerhernand_at_surfside.net
>
> 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 Thu Aug 03 2000 - 05:31:09 CDT