I'm new to Firebird from the ms-sql world, so I'm still learning the
syntax/process differences...

I am calling the "isc_dsql_execute_immediate" function without any
parameter or result buffers (XSQLDA structs).

The only text based column is "label" which is also a varchar(200).

CREATE PROCEDURE sp_daap_cat_add (dbid INTEGER, label VARCHAR(200))
RETURNS ( newid INTEGER )
AS
BEGIN
newid = GEN_ID(daap_cat_gen,1);

INSERT INTO daap_cat (catid,dbid,label,smart,items)
VALUES (:dbid,:newid,:label,NULL,0);

UPDATE daap_db SET dbver = dbver + 1, cats = cats + 1 WHERE
dbid = :dbid;
END



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

>
> > >
> > > > I encounter this error message every time I call a stored
> >procedure
> > > > with a varchar parameter.
> > > >
> > > > Version: Firebird 1.5 embedded
> > > > OS: Windows XP
> > > > Interface: C/C++
> > > >
> > > > Perhaps I have the syntax wrong, but what I'm sending is the
> > > > following:
> > > >
> > > > EXECUTE PROCEDURE sp_myproc 1, 'my name';
> > > >
> > > > And what I *always* get is:
> > > >
> > > > message length error (encountered 0, expected 8)
> > > >
> > > > Is this a bug in my code or firebirds???
> > > >
>
> >--- In firebird-support@yahoogroups.com, Tiago Gouvêa de Oliveira
> ><tiago@n...> wrote:
> > > I Think you need to use
> > >
> > > EXECUTE PROCEDURE sp_myproc(1,'my name');
> > >
> > > Try this..
>
> At 10:53 PM 27/06/2004 +0000, you wrote:
> >That didn't change anything either??
>
> Show us the declaration of the SP.
>
> /heLen