in reply to DBI parse errors

I presume it's just a typo in the code you uploaded here, but you are split()-ing a "|"-delimited file on '/'. If this is not a typo, but in fact your actual code, then split() is putting the entire text of each line into your variable $item, leaving $descr and $latin undefined. This would certainly create problems since you are binding $item as an SQL_INTEGER type.

You also should bind the two other columns. When using prepared statements, I've always bound all parameters. Perhaps I'm unsophisticated, but I cannot grok the advantage of not doing so.

dmm

Just call me the Anti-Gates ...