Hi,

The DBI specification for ParamTypes taken from the DBI pod says the 
following for ParamTypes:

Returns a reference to a hash containing the type information currently 
bound to placeholders.  The keys of the hash are the â??namesâ?? of the 
placeholders: either integers starting at 1, or, for drivers that 
support named placeholders, the actual parameter name string. The hash 
values are hashrefs of type information in the same form as that 
provided to the various bind_param() methods (See "bind_param" for the 
format and values), plus anything else that was passed as the third 
argument to bind_param().  Returns undef if not supported by the driver.

I'm not sure why the values of the keys are hash references unless 
multiple values are to be stored. If multiple values per key are stored 
what are they typically? I can only find one DBD which implements 
ParamTypes (DBD::Pg) and unless I am mistaken it sets the values of the 
keys to a scalar value - the type of the parameter.

Reason I'm asking is it is on my to do list for DBD::ODBC.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com