I'm trying to call a stored procedure using DBD::DB2.
The stored proc has two return values.
I can execute the stored proc just fine in the db2 command line:
call prc_proc(1,"string","string", "string","string", ?,?);
and I get values back.
But when I call this stored proc from within DBI::DB2, I receive the
following error:
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/6000] SQL10013N The
specified library "/eisprddal1/db2/db2mapp2/sqllib/function/prc_proc" could
not be loaded.
DBD::DB2::st fetchrow failed: no statement executing at test_proc.pl line
28.
Here is how I'm approaching it:
$stmt = "call prc_get_relation(2, 'string', 'string', 'string',
'string',?,?)";
$sth = $dbh->prepare($stmt) or die $dbh->errstr;
$sth->bind_param_inout(1, \$x, 34, {ParamT => SQL_PARAM_OUTPUT});
$sth->bind_param_inout(2, \$y, 4, {ParamT => SQL_PARAM_OUTPUT});
$sth->execute();
Any suggestions?
(btw, line 28 is where I do the fetchrow which why it reports the error at
line 28).
Phil
_______________________________________________
Boston-pm mailing list
[EMAIL PROTECTED]
http://mail.pm.org/mailman/listinfo/boston-pm
