Thursday, September 27, 2012

Passing Excess parameter in procedure call

Passing additional parameter in the procedure call:

                      While calling procedure,Sybase passes only required parameters and executed successfully, even we pass the too many parameters .But the SQL Server raises the error while passing too many parameter.
                     If we are passing 4 parameter while calling the 'dbo.calledproc' instead of 3 actual parameter,Sybase engine removes the fourth parameter and pass the first three parameter.But SQL Server raises the below error.

Msg 8144, Level 16, State 2, Procedure CALLED_PROC, Line 0
Procedure or function CALLED_PROC has too many arguments specified.

SQL Server Result while passing Excess parameter

To avoid the above given error,we should remove the additional/unwanted parameters from procedure call.Then the proceudre will get executed succussfully.Find the correct screenshot below. 
      .

Please click here to know about sybase to sql server migration issues

No comments:

Post a Comment