Subject Re: Error when calling a working SP from a trigger:
Author cowmix3
Arrg..

Yeah, it does..

I made a new version without the output parameters and it worked
great..

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?
>
> Regards,
> Arno Brinkman
> ABVisie
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Firebird open source database (based on IB-OE) with many SQL-99
features :
> http://www.firebirdsql.org
> http://www.firebirdsql.info
> http://www.fingerbird.de/
> http://www.comunidade-firebird.org/
>
> Support list for Interbase and Firebird users :
> firebird-support@yahoogroups.com
>
> Nederlandse firebird nieuwsgroep :
> news://80.126.130.81
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 21-3-2005