Error in mysql stored procedure,pls help
Posted by: Bristi Dutta
Date: January 03, 2005 04:56AM

Hi all,
Pls Check the Mysql code.

CREATE PROCEDURE data_insert (First_Name VARCHAR(30) IN, Last_Name VARCHAR(30) IN,Addr VARCHAR(230) IN,
State1 VARCHAR(25) IN,ZIP VARCHAR(20) 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)

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);

END;



I get here a MYSQL 1064 error.
Pls suggest how to recover the error.
Thanks,
Bristi

Options: ReplyQuote


Subject
Written By
Posted
Error in mysql stored procedure,pls help
January 03, 2005 04:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.