At 08:18 PM 1/11/2005 -0800, you wrote:

>No triggers and no events registered. I am calling this stored procedure
>from c# using the Firebird .net interface. The exact error message is
> "validation error for column STORAGEID, value \"*** null ***\"" string
>
>The code calling the stored procedure is
>
>FbCommand cmd = new FbCommand("ADDDIRECTORY", conn);
>
>cmd.CommandType = CommandType.StoredProcedure;
>
>cmd.Parameters.Add("@ID",ids[(int)FileTypes.Other]++);
>
>cmd.Parameters.Add("@PATH", path);
>
>cmd.Parameters.Add("@STORAGEID",0);
>
>
>
>Obviously Firebird knows 0 is not null on an integer.

Strangely enough, yes it does. :-) The point being made is that Firebird
does not (and has no means to) take an integer input value and convert it
to null. So it's your interface that is passing null. It looks as though
you need to ask this question on the firebird-net-provider list, to check
whether this behaviour is a response to some property setting in that
interface.

./heLen