1064 error in Mysql Stored Procedure
Posted by: Bristi Dutta
Date: January 11, 2005 01:06AM

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

The Table as::
CREATE TABLE USER (
USER_ID INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
ROLE_TYPE VARCHAR(15) NOT NULL,
BILLING_FIRST_NAME VARCHAR(25) NOT NULL,
BILLING_LAST_NAME VARCHAR(25) NOT NULL,
ADDRESS VARCHAR(230),
CITY VARCHAR(25),
STATE VARCHAR(25),
COUNTRY VARCHAR(15),
ZIP_CODE VARCHAR(15),
COMPANY_NAME VARCHAR(50),
EMAIL_ID VARCHAR(35),
WORK_PHONE VARCHAR(40),
HOME_PHONE VARCHAR(40),
FAX VARCHAR(40),
MOBILE_PHONE VARCHAR(40),
PRIMARY KEY (USER_ID)
);

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

Options: ReplyQuote


Subject
Written By
Posted
1064 error in Mysql Stored Procedure
January 11, 2005 01:06AM


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.