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

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

Options: ReplyQuote

Written By
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.