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
