Are there any plans to add PL/SQL Object type bindings to DBD::Oracle?
OCI supports it, and I think perl's hashes would make a find psuedo
object we could bind to the PL/SQL for in or in_out variables.
For example:
my $sql = "
DECLARE
in_row myObj;
retcode number;
BEGIN
:retcode := Otherpackage.Function(:in_row);
END;
";
my $sth = $dbh->prepare($sql) ...
Wouldn't it be neat to be able to bind like this:
$sth->bind_param(":in_row", \%hash, { ora_type => ORA_OBJ });
$sth->bind_param_inout(":retcode", $retcode, 10);
$sth->execute();
....
Assuming, of course, that %hash contained keys for all elements of the
PL/SQL object....
--
-Sir Woody Hackswell
