Oddly engough I am working on this kind of thing right now with the vararry
If you have the SQL code (tables functions etc I can work on it a little
more)
Perhaps later this week.
I plan to make a final try at getting this sort of support in DBD::Oracle
1.20 .
I plan to released 1.20 in mid July.
It is all a matter of how much time I have before then.
cheers
John Scoles
----- Original Message -----
From: "Sir Woody Hackswell" <[EMAIL PROTECTED]>
To: <dbi-dev@perl.org>
Sent: Thursday, June 21, 2007 11:43 AM
Subject: PL/SQL Object Type in DBD::Oracle?
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
