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

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?
.

Relevant Pages

  • Re: SqlConnection vs IDbConnection
    ... want to use the prepared statement. ... If your command points to a stored procedure, ... and need it prepared by the underlying provider, ... Note, if your command is a stored procedure, you don't want to call ...
    (microsoft.public.dotnet.languages.csharp)
  • DBD::Sybase - Sybase stored procedure invocation with place holders
    ... when using placeholders in prepared statement handles to a ... I keep getting warnings for each stored procedure ... please destroy and notify sender. ...
    (perl.dbi.users)
  • Re: Prepared Statement and Stored Procedure
    ... my JDBC working with Oracle 9i. ... Stored Procedure and Prepared Statement? ... A stored procedures is something that most database have (in sligthly ...
    (comp.lang.java.programmer)
  • Re: Calling a SQL Server Stored Procedure from within Perl
    ... Thanks for those discussions about warnings and errors. ... I was merely asking for a Perl script that could execute a ... stored procedure. ...
    (comp.lang.perl.misc)
  • Turning off ANSI Warnings
    ... We have discovered that when our merge replicated database receives ANSI ... warnings from a stored procedure, merge replication stops and must be ... Is there a way to supress these warnings? ...
    (microsoft.public.sqlserver.replication)