I didn't set the Direction parameter to input.. Maybe the exception could be
a bit clearer about that?
On 5/14/07, Jon Ege Ronnenberg [EMAIL PROTECTED] wrote:
I did what you posted and it works on some sprocs but not all... sometimes
I get a Dynamic SQL Error
parameter mismatch for procedure
Yes, you're right.
But if you want to use this statement as SP, use it like:
using (FbConnection conn = new FbConnection(cs))
{
conn.Open();
using (FbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = test_insert; // NO test_insert(@id, ...)
cmd.CommandType =
I did what you posted and it works on some sprocs but not all... sometimes I
get a Dynamic SQL Error
parameter mismatch for procedure BE_LOCATION_INFO_INSERT.
I'll look more into this tomorrow with the DBA and post some more info.
On 5/13/07, Jiri Cincura [EMAIL PROTECTED] wrote:
Yes, you're
Jiri you are probably one of the people of this list that knows the most
about Firebird but I have to say (just for the record if anyone else see
this post) that your answer is incorrect. The right statement is execute
procedure BE_BOOKING_INSERT(@BookingID, @UserID, @EventID, @DateFrom,
@DateTo,
Hi all.
I'm trying to insert some data into a stored procedure. It doesn't work.
Either I'm doing it wrong or the stored procedure doesn't work (I didn't
write it). My DAL is pretty generic but my code is kinda like this:
Command.CommandText = BE_BOOKING_INSERT(@EventID, @BookingID, @UserID,