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

  • Thread starter Thread starter Oleg
  • Start date Start date
O

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adobe "Wrong type parameter supplied to a PDS procedure" 0
Call stored procedure in SSMS from Access 2016 doesn't work. 0
calling stored procedures with parameters 3
PARAMETER TO Stored Procedure 6
How to send consecutive stored procedures and its parameters 2
stored procedures passing varchar parameters 1
What's wrong with the SqlParameter? 5
TableAdapter, stored procedure, optional parameters 0

Back
Top