Solved

Does the number of parameter in a stored procedure affect?

Posted on 2011-09-07
2
217 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:
navneethegde earned 500 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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