Nullable parameters in stored procedures

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 28-May-2009 17:52:54   

I am trying to call a proc which has a simple interface:

ALTER PROCEDURE [dbo].[sp_ABC]
(
      @ProcessID int = null,
      @FrequencyID int = null, 

)

I have set the @ProcessID value in the LLBL to "Is Nullable"

When I call the proc:

RetrievalProcedures.ABC(null,1);

I get the error:

Procedure or function 'sp_ABC' expects parameter '@ProcessID', which was not supplied.

What am I missing?

ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 28-May-2009 18:39:30   

My Bad.

I was pointing at the wrong database.

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 28-May-2009 19:50:57   

Easily done simple_smile Thanks for updating.