Subject Re: [firebird-support] Re: Error when calling a working SP from a trigger:
Author Martijn Tonies
> Arrg..
>
> Yeah, it does..
>
> I made a new version without the output parameters and it worked
> great..

Oh, nice error message then :-)

Can I suggest some developer adjust the engine and improve
the error message for this case?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com

> thanks!
>
>
> > Hi,
> >
> > > I am getting this error:
> > >
> > > Invalid token.
> > > invalid request BLR at offset 337.
> > > parameter mismatch for procedure NEW_EBAY_ITEM.
> >
> > <snip>
> >
> > > if (:NEW_STATUS_ID = 40) THEN
> > > EXECUTE PROCEDURE NEW_EBAY_ITEM (new_item_id);
> > >
> > >
> > > If I plug ANY INTEGER into where new_item_id is it still gives me
> that
> > > error..
> >
> > Has the procedure output parameters?