What version of DBI are you using and which DBD driver? You're use of $in{param} leads me to believe you're also using cgi-lib (instead of CGI) and may have a very old installation.

Update: And is this an XY Problem ... are you just trying to get create the next UID ... if so, most DB's have an auto-incrementing field feature.