Classic ASP Discussion - Procedure ’sp_InsertProfile’ expects para

Print Page | Close Window

Procedure ’sp_InsertProfile’ expects para

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=2410
Printed Date: 29 March 2026 at 2:58pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Procedure ’sp_InsertProfile’ expects para

Posted By: raj74
Subject: Procedure ’sp_InsertProfile’ expects para
Date Posted: 04 May 2003 at 7:52am

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 mailto:'@Expect' - '@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 mailto:=@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

Replies:

Posted By: Bunce
Date Posted: 04 May 2003 at 10:36pm

You've got two parameters there in your SP.

Are you also providing the @Name parameter?

-------------
There have been many, many posts made throughout the world...
This was one of them.