Re: Error in mysql stored procedure,pls help
Posted by: Andrew Gilfrin
Date: January 26, 2005 10:45AM

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

The problem is with you parameter declaration, you need to do it as follows.

(IN company varchar(50))

The IN needs to be the first thing in the list not the last.

Andrew Gilfrin
www.mysqldevelopment.com

Options: ReplyQuote


Subject
Written By
Posted
Re: Error in mysql stored procedure,pls help
January 26, 2005 10:45AM


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.