| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Line Overflow Error. ORA-20000: ORU-10028
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)||'
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,
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
 |
 |