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
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
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.CommandTyp
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,
Jon Ege Ronnenberg wrote:
> The question is what is the right syntax and do I need to set anything
> else on Command object?
The first is right.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
--
