I had to get the TYPE info from the statment handle before calling $sth->finish();.

Also from the DBI documentation: how to get the SQL names for those data type integers:

    {
        no strict 'refs';
        foreach (@{ $DBI::EXPORT_TAGS{sql_types} }) {
            printf "%s=%d\n", $_, &{"DBI::$_"};
        }
    }
[download]