ado.net-stored procedure - null value in parameter question

[Oleg]

I am trying to send one of the parameters of stored
procedure having a null value. The parameter is of type
blob. I declare it in code like 'new OleDbParameter
("p_sigPicture", OleDbType.LongVarBinary)'.
The result of execution is exception: 'Stored Procedure
is not found'.
I don't want to make another stored procedure for the
case when the is no parameter to pass.
What can I do to pass a null value?

 

[Miha Markic]

Hi Oleg,

It sounds to me that your stored procedure name in CommandText is wrong.

 

[Guest]

The name is correct. I checked.