Skip to Content.
Sympa Menu

freetds - Re: [freetds] ODBC stored procedures broken in CVS?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ODBC stored procedures broken in CVS?
  • Date: Wed, 30 Nov 2005 13:16:23 +0100

>
> When I SQLExecDirect a simple query like:
>
> {CALL myproc('value')}
>
> Something is attempting to parse/prepare my procedure call the
> database error I'm getting back is along the lines of "the required
> parameter of myproc is missing"
>
> Checking profiler my procedure is being sent as 'myproc' only
> with the
> constant 'value' parameter stripped out.
>
> It looks like this happened with changes between 1.19 and 1.22 of
> native.c.
>
> I fixed it for me easy enough by moving the return
> SQL_SUCCESS; in the
> default switch case unconditionally in prepare_call.. but I
> suspect there
> needs to be some sort of memory of previous
> parameters/counter to bail out
> if one or more place holders are found and I suspect
> something else might
> not be right... I'm too ignorant in this area to try and submit a
> patch...sorry :(
>
> take care,
> Peter

You are right... fixed in CVS (attached patch).
Well, we implemented RPC calls using ALWAYS RPC calls but we do not
handle this case (RPC with no dynamic parameters)

freddy77

Attachment: vedi.diff
Description: vedi.diff




Archive powered by MHonArc 2.6.24.

Top of Page