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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net