On 3?30?, ??9?54?, Sandy <S...@discussions.microsoft.com> wrote:
> Can someone tell me what I am doing wrong in the following procedure? When
> I try to execute it, I get an error saying @LoanID was not supplied.
>
> Alter PROCEDURE InsertIntoFourTables
>
> -- For tblLoans
> @DateEntered datetime,
> @DisasterNo varchar(20),
> @DCMSNo varchar(20),
> @PMQDDueDate datetime,
> @Department varchar(5),
> @LoanType varchar(50),
>
> -- For tblAddresses
> @AddressLine1 varchar(100),
> @AddressLine2 varchar(100),
> @City varchar(50),
> @State varchar(2),
> @Zip varchar(20),
>
> -- For tblBorrower
> @BorrowerFirst varchar(50),
> @BorrowerMI varchar(5),
> @BorrowerLast varchar(50),
> @BorrowerSuffix varchar(5),
>
> -- For tblPhone
> @PhoneNumber varchar(15),
>
> -- Get identity keys
> @LoanID int OUTPUT,
> @BorrowerID int OUTPUT
>
> AS
> BEGIN
> SET NOCOUNT ON;
>
> Insert into tblLoans
> Values
> (@DateEntered,
> @DisasterNo,
> @DCMSNo,
> @PMQDDueDate,
> @Department,
> @LoanType
> )
>
> Set @LoanID = SCOPE_IDENTITY()
> Insert into tblAddresses
> Values
> (@AddressLine1,
> @AddressLine2,
> @City,
> @State,
> @Zip,
> @LoanID
> )
>
> Insert into tblBorrower
> Values
> (@BorrowerFirst,
> @BorrowerMI,
> @BorrowerLast,
> @BorrowerSuffix,
> @LoanID
> )
> Set @BorrowerID = SCOPE_IDENTITY()
> Insert into tblPhone
> Values
> (
> @PhoneNumber,
> @BorrowerID
> )
>
> END
> GO
>
> Any help will be greatly appreciated!
you add some debug prints inside the proc to see if any error fired.