Thursday, September 27, 2012

Missing parameter in procedure call

Expects Parameter in the procedure call:

                 While calling procedure,Sybase adding NULL for the required parameters and executed successfully, even we miss to pass some parameters .But the SQL Server raises the error while missing to pass some parameters.
                     If we are passing 2 parameter while calling the 'dbo.calledproc' instead of 3 actual parameter,Sybase engine adds NULL for the third parameter.But SQL Server raises the below error.
Msg 201, Level 16, State 4, Procedure CALLED_PROC, Line 0
Procedure or function 'CALLED_PROC' expects parameter '@PARAMETER3', which was not supplied.


SQL Server Result wihile missing parameter in procedure call


To avoid the above given error,we should add NULL for remaining parameters for 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