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