You might try the trace features of DBI to see more of what is going on.
In reply to Re^3: SQL through perl is giving error by Anonymous Monk in thread SQL through perl is giving error by ksublondie