hi guys,
When i try to insert a record from asp by calling a stored procedure in sql server2000 i am getting the following error.
the error is ...
Microsoft OLE DB Provider for SQL Server error '80040e10'
Procedure 'sp_InsertProfile' expects parameter '@Expect', which was not supplied.
my stored procedure is ...
CREATE PROCEDURE sp_InsertProfile
(
@Name varchar(50),
@Expect varchar(500)
)
AS
IF EXISTS(SELECT Serial_No from Profile_Details Where Profile_ID =@Profile_ID)
return(0)
ELSE
INSERT INTO Profile_Details
(Name,Expectation)
VALUES
(@name,@Expect)
RETURN @@IDENTITY
SET NOCOUNT OFF
GO
my asp coding is ...
...
commInsert.Parameters.Append commInsert.CreateParameter("@Expect",adVarChar,1,500,vExpectation)
commInsert.Execute()
thanks in advance
raj74