HEllo Team,
I have the Stored Procedure like this:
But I am getting the following error:
Procedure or function 'UpdateQCVerify' expects parameter '@CUSTOMERLOANDATAID', which was not supplied.
ALTER PROCEDURE [dbo].[UpdateQCVerify]
@CUSTOMERLOANDATAID int,
@BATCHID int,
@CUSTOMERLOANOCRID int,
@FILELOGID int,
@FILENAME varchar(MAX),
@RECORDNO int,
@FIRSTNAME varchar(25),
@MIDDLENAME varchar(25),
@LASTNAME varchar(25),
@GENDER varchar(6),
@FULLADDRESS varchar(MAX),
@CUSTOMERADDR1 varchar(100),
@CUSTOMERADDR2 varchar(100),
@LANDMARK varchar(50),
@CITY varchar(20),
@STATE varchar(20),
@PINCODE varchar(7),
@LANDLINENO varchar(15),
@MOBILENO1 varchar(15),
@MOBILENO2 varchar(15),
@EMAILID varchar(50),
@DOB smalldatetime,
@ADDRVERIFY varchar(3),
@PHOTOVERIFY varchar(3),
@LOAN1AMT decimal(18, 2),
@LOAN1INTRRATE decimal(18, 2),
@LOAN2AMT decimal(18, 2),
@LOAN2INTRRATE decimal(18, 2),
@DATEOFEMI smalldatetime,
@RELEASEDATE smalldatetime,
@MOTHERNAME varchar(25),
@HOUSETYPE varchar(15),
@COMPANYNAME varchar(50),
@SALARY decimal(18, 2),
@QCREMARKS varchar(1),
@UPDATEDBY int,
@UPDATEDON datetime
AS
BEGIN
update CUSTOMERLOANDATA WITH (ROWLOCK)
set
BATCHID=@BATCHID,
CUSTOMERLOANOCRID= @CUSTOMERLOANOCRID,
FILELOGID = @FILELOGID,
[FILENAME] = @FILENAME,
RECORDNO = @RECORDNO,
FIRSTNAME = @FIRSTNAME,
MIDDLENAME = @MIDDLENAME,
LASTNAME = @LASTNAME,
GENDER = @GENDER,
FULLADDRESS = @FULLADDRESS,
CUSTOMERADDR1 = @CUSTOMERADDR1,
CUSTOMERADDR2 = @CUSTOMERADDR2,
LANDMARK = @LANDMARK,
CITY = @CITY,
STATE = @STATE,
PINCODE = @PINCODE,
LANDLINENO = @LANDLINENO,
MOBILENO1 = @MOBILENO1,
MOBILENO2 = @MOBILENO2,
EMAILID = @EMAILID,
DOB = @DOB,
ADDRVERIFY = @ADDRVERIFY,
PHOTOVERIFY = @PHOTOVERIFY,
LOAN1AMT = @LOAN1AMT,
LOAN1INTRRATE = @LOAN1INTRRATE,
LOAN2AMT = @LOAN2AMT,
LOAN2INTRRATE = @LOAN2INTRRATE,
DATEOFEMI = @DATEOFEMI,
RELEASEDATE = @RELEASEDATE,
MOTHERNAME = @MOTHERNAME,
HOUSETYPE = @HOUSETYPE,
COMPANYNAME = @COMPANYNAME,
SALARY = @SALARY,
QCREMARKS = @QCREMARKS,
UPDATEDBY = @UPDATEDBY,
UPDATEDON = @UPDATEDON
where id = @CUSTOMERLOANDATAID
End
Please let me know where i made the mistake.its a very sily mistake i am making .
Thanks
Harshal Raut