Problem with DBD::ODBC

[Deepak Sharma]

Hi All,

It seems that DBD::ODBC is not returning string values. It's returning
int values correctly. For string return values it retuns only first char
of retrun value.

I am using Perl 5.6, Win 2000, MS SQL Version 7.

Here is my code.
#### Perl Code
my $sth = $db->prepare("{call SP_Get_Max_OrderID(?,?)}");
$sth->bind_param_inout(1,\$retValue1, 32);
$sth->bind_param_inout(2,\$retValue2, 32); $sth->execute;

--Stored proc
CREATE PROCEDURE SP_Get_Max_OrderID 
        @MaxOrderID1      int OUTPUT,
        @MaxOrderID2    varchar(32) OUTPUT AS
  
  SELECT @MaxOrderid1 = 200 + 100
  SELECT @MaxOrderid2 = '200' + '100'
    
  return (0)
----

Can any body help.

Thanks
Deepak