Subject | Re: [firebird-support] Re: Error when calling a working SP from a trigger: |
---|---|
Author | Martijn Tonies |
Post date | 2005-03-23T07:27:47Z |
> Arrg..Oh, nice error message then :-)
>
> Yeah, it does..
>
> I made a new version without the output parameters and it worked
> great..
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?