Re: [Firebird-odbc-devel] Commas, Stored Procedures and string parameters

[Jorge A. B. <jor...@gm...>]

If I replace "call" for "execute procedure" works fine, comma included.

Could be a "call" implementation bug?

2008/12/4 Jorge Andrés Brugger <li...@da...>

> Hi.
>
> I´ve a SP that receives a string (varchar) as parameter. It´s something
> like:
>
> CREATE PROCEDURE SP_EMITIR_PEDIDO_INTERNO (
>    sucursal smallint,
>    numero_pedido_interno integer,
>    usuario smallint,
>    observaciones varchar(2500))
> as
> begin
>  /* do something */
>  exit;
> end
>
>  From my app, I call it as:
>
> call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string')
>
> and works fine. But it including a comma in string, like:
>
> call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string, with a comma')
>
> it fails with "SQL Error code -104 Unexpected end of command - line 1,
> column 51"
>
> ¿Why?
>
> Thanks.
>
> --
> Jorge Andrés Brugger
> Informática
> DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
> Comodoro Rivadavia, Chubut, Argentina
> Teléfono (0297) 446-4444 int. 103
> Correo electrónico: jbr...@da...
> Website: www.dasu.com.ar
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>