DBD::Sybase - Sybase stored procedure invocation with place holders

This feels like a silly question. Anyone ever have trouble with
DBD::Sybase, when using placeholders in prepared statement handles to a
stored procedure exec?

On $sth->execute, I keep getting warnings for each stored procedure
parameter, stating that it hasn't been provided.

I tried to explicitly bind these by TYPE=>DBI::SQL_<TYPE>s. No change.


However, when I forsake reusing the $sth and hard code in my parameter
values, everything works great. I tried to do this without affecting
the original message using $sql2 =~ s{(?<!')\?}{$value} type statements
( we pass = '?' as hard coded literals in places ). Is there an issue
with the bind? I tried both bind_param and execute($arg1,..., $argn) -
both seem to fail. Could the problem be related to the fact that this
stored procedure has quite a large signature (>100 parameters)?

This only seems to be a problem when executing stored procedures and not
in other update/insert contexts.

Familiar? Any ideas?

Thanks,

Raf
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.
.

Relevant Pages