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

[Jorge A. B. <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