INSERT stored procedure does not work?

Posted by vikitor on Stack Overflow See other posts from Stack Overflow or by vikitor
Published on 2010-05-18T13:49:38Z Indexed on 2010/05/18 14:01 UTC
Read the original article Hit count: 269

Hello, I'm trying to make an insertion from one database called suspension to the table called Notification in the ANimals database. My stored procedure is this:

ALTER PROCEDURE [dbo].[spCreateNotification] 
 -- Add the parameters for the stored procedure here
 @notRecID int,
 @notName nvarchar(50),
 @notRecStatus nvarchar(1),
 @notAdded smalldatetime,
 @notByWho int
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 INSERT INTO Animals.dbo.Notification 
 values (@notRecID, @notName, @notRecStatus, null, @notAdded, @notByWho);
END

The null inserting is to replenish one column that otherwise will not be filled, I've tried different ways, like using also the names for the columns after the name of the table and then only indicate in values the fields I've got. I know it is not a problem of the stored procedure because I executed it from the sql server management studio and it works introducing the parameters. Then I guess the problem must be in the repository when I call the stored procedure:

public void createNotification(Notification not)
        {
            try
            {
                DB.spCreateNotification(not.NotRecID, not.NotName, not.NotRecStatus,
                                        (DateTime)not.NotAdded, (int)not.NotByWho);

            }
            catch
            {
                return;
            }
        }

It does not record the value in the database. I've been debugging and getting mad about this, because it works when I execute it manually, but not when I automatize the proccess in my application. Does anyone see anything wrong with my code?

Thank you

© Stack Overflow or respective owner

Related posts about stored-procedures

Related posts about sql