>
>
> 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)
> ----
>
Please make sure you are running with MDAC 2.7 installed on your client (and
possibly the server, too).
If you are still having problems with this, post back here with a level 9
DBI trace file.
Thanks,
Jeff
