Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0011927Openbravo ERPY. DBSourceManagerpublic2010-01-11 11:022012-09-24 23:40
feiyu311 
marvintm 
lowminorhave not tried
scheduledopen 
10XP Professional
2.50MP6 
 
Core
No
0011927: Label in function can make the update.database failed
I have a function which contains labels like <<L1>> , when export, it can exported to XML correctly, but when update, the error will occur.

My database function like this:
<<L1>>
LOOP
  BEGIN
    //INSERT INTO statements
  EXIT L1;

  EXCEPTION WHEN unique_violation THEN
   v_c_bp_id:='';
  END;
END LOOP;
No tags attached.
log update.database.log (12,537) 2010-01-11 11:02
https://issues.openbravo.com/file_download.php?file_id=2112&type=bug
Issue History
2010-01-11 11:02feiyu311New Issue
2010-01-11 11:02feiyu311Assigned To => marvintm
2010-01-11 11:02feiyu311File Added: update.database.log
2010-01-19 09:41alostaleStatusnew => scheduled
2010-01-19 09:41alostalefix_in_branch => pi
2010-01-31 14:29feiyu311Issue Monitored: feiyu311
2012-03-14 12:47marvintmTypedefect => design defect
2012-03-14 12:47marvintmfix_in_branchpi =>
2012-09-24 23:40AugustoMauchNote Added: 0052514
2012-09-24 23:40AugustoMauchPrioritynormal => low

Notes
(0052514)
AugustoMauch   
2012-09-24 23:40   
Impact: low
Plan: long