Click here to Skip to main content
15,889,861 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
DELIMITER $$

CREATE PROCEDURE `cms`.`SetRegistration`()
 
 
     
	in p_EnquiryID int,
	in p_Date datetime,
	in p_ProjectTopic varchar(100),
	in p_Staff varchar(30),
	in p_TotalFess int,
	in p_Fees int,
	In p_Description varchar(250),
	in p_IsActive boolean,
	in p_BranchStatus int
		
    BEGIN

		INSERT INTO tblregistration(Enquiry_ID,Date,ProjectTopic,Staff,Fees_ID,Description,Status,BatchStatus)
		values(p_EnquiryID,p_Date,p_ProjectTopic,p_Staff,p_TotalFess,p_Fees,p_Description,p_IsActive,p_BranchStatus);

    END$$


DELIMITER $$
Posted
Comments
[no name] 19-Aug-14 10:46am    
Your columns and values do not match

1 solution

SQL
INSERT INTO tblregistration(Enquiry_ID,Date,ProjectTopic,Staff,Fees_ID,Description,Status,BatchStatus)
values(p_EnquiryID,p_Date,p_ProjectTopic,p_Staff,p_TotalFess,p_Fees,p_Description,p_IsActive,p_BranchStatus);

p_TotalFees is redundant.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900