TZStroredProc issue with Sybase ASE 15.5

[Sebastien]

Hi,

I have a problem with TZStoredProc and the params value send to Sybase.
My stored proc is :

Code: Select all

CREATE PROCEDURE dbo.TEST
@NUCAMP int,@RANGACT int,@SOC int,
@SOCPRT  int
AS
BEGIN 
  insert into TMP values (@NUCAMP,@RANGACT,@SOC, @SOCPRT, getdate())
END

The table TMP :

Code: Select all

create table TMP (
  N_NUCAMP int Null,
  N_RANGACT int Null,
  N_SOC int Null,
  N_SOCPRT int Null,
  SYB_DATE datetime Null)
 go

The TZStoredProc don't send the correct values for parameters.
For example : no matter what values i set to the parameters (except null) the procedure recieve always 1,1,1,1.

If i use a TZQuery instead of TZStoredProc, the procedure recieve the good parameters.

I'm using Zeoslib 7.1.3, but i have the same behavior with 7.1.4, 7.2 and 7.3 (all from SVN repository).

[jerome]

I confirm this bug , it is very debilitating ...

[marsupilami]

Hello,

I have found that bug too and solved it - but only for Zeos 6.6. I will port the patch later this day to Zeos 7.1 and attach the new patch to this thread.
With best regards,

Jan