gomag-vending

Files

Claude Agent e42b1f63b7 fix(address): ORA-06502 pe apart/scara/etaj token lung + strip city+region din adresa GoMag

Doua root cause-uri pentru ORA-12899 la importul comenzii #485841056:

1. Oracle ORA-06502: v_apart/v_scara/v_bloc/v_etaj in cauta_sau_creeaza_adresa
   declarate VARCHAR2(10/20/30) → Oracle mostenea constrangerea pe OUT parametrii
   din parseaza_adresa_semicolon → crash INAINTE de fix-ul overflow de la linia 521.
   Fix: marite la VARCHAR2(100).

2. Python format_address_for_oracle stripuia doar city exact, nu si 'city region'
   sau 'region city'. GoMag trimite adresa cu suffix 'Municipiul Bucuresti Bucuresti'
   (city+region) → token urias pentru apartament → declansa ORA-06502 de mai sus.
   Fix: incearca toate combinatiile city+region, region+city, city, region.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

2026-04-28 10:31:05 +00:00

01_create_table.sql

Remove FXP files from tracking and update gitignore

2025-09-09 19:38:31 +03:00

04_pack_comenzi.pck

adaugare adauga_comanda_pe_factura()

2026-04-15 14:42:17 +00:00

05_pack_import_parteneri.pck

fix(address): ORA-06502 pe apart/scara/etaj token lung + strip city+region din adresa GoMag

2026-04-28 10:31:05 +00:00

06_pack_import_comenzi.pck

fix(import): resolve duplicate article + order_items repopulation on retry