DBD::Oracle through DBD::Proxy .. stored procedures help
I am trying to call a simple stored procedure. I use DBD::Proxy, connecting
to an Oracle database. I tried the same code on a machine that uses
DBD::Oracle directly (to the same database) and it WORKS. Using it through
the DBD::Proxy yields the error below. Is there a way to get stored
procedures to work in Oracle through the proxy?
Thanks.
$sth = $dbi->prepare(" BEGIN :result := sf_a2n(234); END; ");
my $result = "";
$sth->bind_param_inout(":result", \$result, 50);
$sth->execute;
I get the following error on the bind_param_inout line:
DBD::Proxy::st execute failed: Server returned error: Failed to execute
method CallMethod: Can't bind a reference (SCALAR(0x4256b4))
