I work with perl 5.8.8. I have a problem when I execute a stored procedure. I pass the parameters
as a hash. One of output parameters is of type "DATE".
If I write:
my_par_type_date => { length => 20, type => &ORA_DATE }
or
my_par_type_date => { length => 7, type => &ORA_DATE }
I get:
ora_type 12 not supported by DBD::Oracle
If I write:
my_par_type_date => => { length => 20, type => &ORA_VARCHAR2 }
I get (by Data::Dumper) the values of parameters not corresponding to the keys (the mess concerns the other parameters, not my_par_type_date).
Finally,if I write
my_par_type_date => { length => 20, type => 12 }
all the output parameters are undef and one of them (not my_par_type_date) is not viewed by Dumper.
