Does the number of parameter in a stored procedure affect?

First I called the Stored Procedure:
 res = procs.ProcessARWD(msg.OrderRef, msg.Lgv, msg.DestinationLocation, msg.DestinationLevel, true, resultCode, resultMsg, resultTimeStamp).ToList<EF.ProcessMasterMsg_Result>();

Second
I am creating a message by using type table in SQL Server 2008.
Type table
declare @ReturnValues                              AS  dbo.[tvpReturnValue]

INSERT INTO @ReturnValues
                  (
                        MessageType,      MissionRef,                              Priority,
                        Row,                  ProductType,                        LoadAidType,
                        LgvSearchEnable,LevelSearchEnabled,                  SideSearchEnabled,                  PressureGaugeEnabled,
                        Stability,                                                      TrackingID,                              
                        LPN,                  RFID,                                    OrderNumber,
                        PickLocation,      PickPosition,                        PickLevel,                              PickHeight,                        PickDistance,
                        DropLocation,                                                DropPosition,                        
                        DropLevel,            DropHeight,                              DropDistance,
                        WeightPalletsInLocation , NumPallets, SequenceNumber, WrappedStatus, ShipmentNr
                  )      
                  VALUES
                  (
                        'DPOS',                  @TaskNumber,                        10,
                        @Row,                  1,                                          ISNULL(@palletTypeFromDB,1),                        
                        1,                        1,                                          1,                                          1,
                        ISNULL(@stabilityStatusFromDB, 1),                  NULL,
                        @Lpn,                  @graiCode,                              NULL,
                        NULL,                  0,                                          0,                                          0,                                    0,
                        @NextStorageOpPointName,                              @positionLgvCs,            
                        @LevelLgvCs,      @Height,                              0,
                        @TotalWeight      , @NumPallets      , @SequenceNumber      , @wrappedStatus      , @ShipmentNumber
                  )

Then, I return the values with:select *
      from @ReturnValues
      
END TRY
 

The ReturnValues should be now in res but I am not getting all of them.
@TotalWeight      and @NumPallets are the main ones that I need.

any ideas will be good.

Thank you.



iscivanomarAsked:
Who is Participating?
 
NavneetConnect With a Mentor Software EngineerCommented:
Hi!

Is your parameter type OUTPUT
check this
http://msdn.microsoft.com/en-us/library/ms187004.aspx

Thanks!
0
 
iscivanomarAuthor Commented:
Sorry for not getting back to you soon, I was in vacation. and thank you for your answer. It help me to find the error that I was getting.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.