?
Solved

Does the number of parameter in a stored procedure affect?

Posted on 2011-09-07
2
Medium Priority
?
247 Views
Last Modified: 2012-05-12
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.



0
Comment
Question by:iscivanomar
2 Comments
 
LVL 15

Accepted Solution

by:
Navneet earned 2000 total points
ID: 36500810
Hi!

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

Thanks!
0
 

Author Closing Comment

by:iscivanomar
ID: 36602154
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question