Re: Need help on Mysql Store Procedure(Front end is Java Swing)
Hi Mathews,
Thank you,very much for your reply.But if you have time then please check the following codes, I write to create store procedure.Whenever I want to run the code in MYSQL a MYSQL 1064 error occur::
CREATE PROCEDURE data_insert (IN First_Name VARCHAR(25),IN Last_Name VARCHAR(25),IN Addr VARCHAR(230),
IN State1 VARCHAR(25),IN ZIP VARCHAR(15),IN Company VARCHAR(50),IN Email VARCHAR(35),In WPhone VARCHAR(40),IN HPhone
VARCHAR(40),IN Fax VARCHAR(30),IN MPhone VARCHAR(40),IN S_Address VARCHAR(230),IN S_City VARCHAR(15),
IN S_State VARCHAR(15),IN S_Zip VARCHAR(15),IN S_Phone VARCHAR(15),IN S_Description VARCHAR(40),
IN S_ClosingComment VARCHAR(230),IN S_EstID INT,IN S_Estimator VARCHAR(40))
BEGIN
INSERT into user (billing_first_name,billing_last_name,address,state,zip_code,company_name,email_id,
work_phone,home_phone,fax,mobile_phone)values(First_Name,Last_Name,Addr,State1,ZIP,Company,Email,
WPhone,HPhone,Fax,MPhone);
INSERT into work_site (address,city,state,zip_code,phone,site_description,closing_comment,estimator_id,
estimator_no)values(S_Address,S_City,S_State,S_Zip,S_Phone,S_Description,S_ClosingComment,S_EstID,S_Estimator);
END
Please help me to recover the error.
Thanks,
Bristi