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.
Please click here to know about sybase to sql server migration issues
No comments:
Post a Comment