Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

[Stephen More]

On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote:

Stephen. I would try correcting your code which calls bind_param incorrectly:

$sth->bind_param(1, \$a ); -> $sth->bind_param(1, $a );
$sth->bind_param(2, \$b ); -> $sth->bind_param(2, $b );

I changed my code with:
$sth->bind_param(1, $a );
$sth->bind_param(2, $b );

But I am still getting "DBD::ODBC::st execute failed:
[unixODBC][IBM][iSeries Access ODBC Driver]Error in assignment"

BTW
  what is with all those "my( $a ) = 1;" statements? You don't need the ().

I know they are not needed...This was a company coding standard that
was put in place and I have been following it ever since :-)

  and why do "$ENV{PERL_DL_NONLAZY}=1;"?

This is left over from a previous problem...actually you told me to try it.
In May of 2005 I was getting a seg fault:
http://www.codecomments.com/archive237-2005-5-498915.html


-Thanks for you assistance
Steve More