Hello Team,
This is my one stored procedure as follow:
ALTER PROCEDURE [dbo].[UpdateCustomerLoanOCR]
@CUSTOMERLOANOCRID int,
@UPDATEDBY int,
@UPDATEDON datetime
AS
BEGIN
update CUSTOMERLOANOCR WITH (ROWLOCK)
set
processed = 1,
UpdatedBy = @UPDATEDBY,
UpdatedOn = @UPDATEDON
where id = @CUSTOMERLOANOCRID
End
This is my second Stored Procedure as follows
CREATE PROCEDURE InsertRecordInAuditCustomerLoanData
@CustomerLoanDataID INT
AS
BEGIN
Insert into AUDIT_CUSTOMERLOANDATA (CUSTOMERLOANDATAID,BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID ,
DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI ,
RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 ,
CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE ,
ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY,
CREATEDON,QCTOVERIFYREMARKS,ISD1,ISD2,STD1,QCPROCESSED)
Select ID,BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID ,
DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI ,
RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 ,
CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE ,
ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY,
CREATEDON,QCTOVERIFYREMARKS,ISD1,ISD2,STD1,QCPROCESSED
from CUSTOMERLOANDATA (nolock)
where id = @CustomerLoanDataID
select @CustomerLoanDataID
end
this is my third Stored Procedure
ALTER PROCEDURE [dbo].[AddCustomerLoanData]
@BATCHID int,
@FILELOGID int,
@FILENAME varchar(max),
@RECORDNO int,
@FIRSTNAME varchar(25),
@MIDDLENAME varchar(25),
@LASTNAME varchar(25),
@MOTHERNAME varchar(25),
@FULLADDRESS varchar(max) ,
@MOBILENO varchar(15),
@EMAILID varchar(50),
@DOB datetime = NULL,
@LOAN1INTRATE decimal(18,2),
@LOAN1AMT decimal(18,2),
@LOAN2INTRATE decimal(18,2),
@LOAN2AMT decimal(18,2),
@DATEOFEMI datetime= NULL ,
@RELEASEDATE datetime= NULL,
@HOUSETYPE varchar(15),
@SALARY decimal(18,2),
@CUSTOMERLOANOCRID int,
@CUSTOMERADDR1 varchar(100),
@CUSTOMERADDR2 varchar(100),
@LANDMARK varchar(50),
@STATE varchar(20),
@CITY varchar(20),
@PINCODE varchar(7),
@ADDRVERIFY varchar(3),
@PHOTOVERIFY varchar(3),
@GENDER varchar(6),
@LANDLINENO varchar(15),
@MOBILENO2 varchar(15),
@COMPANYNAME varchar(50),
@CREATEDBY int,
@CREATEDON datetime,
@QCTOVERIFYREMARKS varchar(max),
@ISD1 varchar(5),
@ISD2 varchar(5),
@STD1 varchar(5),
@ID INT OUT
AS
BEGIN
insert into
CUSTOMERLOANDATA (BATCHID,FILELOGID,[FILENAME],RECORDNO,FIRSTNAME,MIDDLENAME, LASTNAME ,MOTHERNAME,FULLADDRESS ,MOBILENO1 ,EMAILID ,
DOB, LOAN1INTRATE ,LOAN1AMT ,LOAN2INTRATE ,LOAN2AMT ,DATEOFEMI ,
RELEASEDATE, HOUSETYPE ,SALARY ,CUSTOMERLOANOCRID ,CUSTOMERADDR1 ,
CUSTOMERADDR2 ,LANDMARK ,STATE ,CITY ,PINCODE ,
ADDRVERIFY ,PHOTOVERIFY ,GENDER ,LANDLINENO ,MOBILENO2 ,COMPANYNAME,CREATEDBY, CREATEDON,QCTOVERIFYREMARKS,
ISD1,ISD2,STD1)
values(@BATCHID, @FILELOGID, @FILENAME, @RECORDNO, @FIRSTNAME, @MIDDLENAME, @LASTNAME, @MOTHERNAME ,@FULLADDRESS , @MOBILENO ,@EMAILID ,
@DOB ,@LOAN1INTRATE ,@LOAN1AMT ,@LOAN2INTRATE ,@LOAN2AMT ,@DATEOFEMI ,
@RELEASEDATE ,@HOUSETYPE ,@SALARY ,@CUSTOMERLOANOCRID ,@CUSTOMERADDR1 ,
@CUSTOMERADDR2 ,@LANDMARK ,@STATE ,@CITY ,@PINCODE,
@ADDRVERIFY ,@PHOTOVERIFY,@GENDER ,@LANDLINENO ,@MOBILENO2 ,@COMPANYNAME, @CREATEDBY ,@CREATEDON,@QCTOVERIFYREMARKS,
@ISD1,@ISD2,@STD1 )
SET @ID = @@IDENTITY;
exec UpdateCustomerLoanOCR
exec InsertRecordInAuditCustomerLoanData
End
I want to call first and second Stored Procedure in Third procedure.As i call the first and second Stored Procedure in Third procedure but it gives me error the Procedure or function 'UpdateCustomerLoanOCR' expects parameter '@UPDATEDBY', which was not supplied.As there are three parameters are present in UpdateCustomerLoanOCR and one parameter is present in InsertRecordInAuditCustomerLoanData.Please kindly tell me how should i get this solve.Is this is the right way to call procedure from one to another?
Thanks
Harshal