Re: [Firebird-net-provider] Executing Procedure Error Help Please!

[Oleg D. <ol...@td...>]

Hello,

Charles Urbina said the following on 18.04.2006 17:57:

> [FbException (0x80004005): Dynamic SQL Error
> parameter mismatch for procedure INSERT_RESERVATION]

It is the cause of error.

Replace this:

> FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
> INSERT_RESERVATION", myConnection, myTransaction);

with something like this:

FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
INSERT_RESERVATION(@COMPANY_NAME, @PASSENGER_NAME)", myConnection,
myTransaction);

-- 
Oleg