i am using mysql 4.0.17 max-debug and DBI 1.38. i am just using USE:DBI. I realised the thing you said about arrayrefs and changed it , but the problem still remains with the loops.