Re: Help sought with definition and implementation of ParamTypes attribute

Martin Evans wrote:
> Thanks to all who have responded with clarification. I have 
> implemented ParamTypes in DBD::ODBC as a hash reference with parameter 
> number as key and each value is a hash reference with keys of 'TYPE' 
> and values of SQL type number.
>
> This will be in 1.17_2.
>
> Martin
One last thing that came to mind when I was doing this. Is a DBD author 
free to add additional keys to the hashref hanging off the parameter 
key? I only ask because in DBD::ODBC's case there is some other useful 
info that it could be provide including:

o the described type (i.e., the SQL type SQLDescribeParam returned) 
which may be different from the bound type if you specify a bind type.

o the parameter size

o decimal digits, scale

o nullable

In addition, for all DBD's you cannot tell if the parameter was bound as 
in or in/out.

Martin