Click here to Skip to main content
15,886,074 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Posted
Comments
Andrius Leonavicius 10-Feb-14 7:17am    
Hi,

The procedure itself looks OK. How you're calling it?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900