Ismail, Rafiq (IT) wrote:
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?
Have you read the DBD::Sybase documentation?
