[freetds] Getting stored procedure output parametersandreturnvalues

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Thu Apr 12 09:39:51 EDT 2007


> 
> Thank you very much Frediano.
>   I really would be thankful if you could send me this test.
>   ...
>   

There were a very similar test in funccall.
Now I even imported your test (which work flawlessly), see
http://freetds.cvs.sourceforge.net/freetds/freetds/src/odbc/unittests/funccall.c?revision=1.14&view=markup

freddy77


> 
> "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio at vodafone.com> escreveu:
>   > 
> > Hi Frediano, thank's for your help.
> > 
> > But problem continues. In odbc32 from Microsoft, I do this. 
> > It realy works.
> > But in unixODBC don't.
> > 
> > My SP do not return record sets or rows affected, simply 
> > set an output parameter. 
> > 
> > See:
> > 
> > create procedure sp_test
> > @res int output
> > as 
> > set @res = 456
> > 
> 
> This should be related to how tokens are readed.. ms odbc 
> usually handle
> more tokens so it catches parameters earlier. Current CVS (I don't
> remember 0.64) should handle tokens quite accurately. I'll do a check,
> perhaps there's already a test for this problem.
> 
> freddy77
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 
> 
> Atenciosamente,
> João M L Amaral
>  __________________________________________________
> Fale com seus amigos  de graça com o novo Yahoo! Messenger 
> http://br.messenger.yahoo.com/ 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 


More information about the FreeTDS mailing list