MySQL Forums
Forum List  »  Stored Procedures

Re: Enum as a parameter in Procedure, how to do it ??
Posted by: Devart Team
Date: October 01, 2012 01:03AM

You should specify all enum values in procedure declaration, e.g. -

CREATE PROCEDURE `schemaname`.`test`(data ENUM('one','two','three'))
BEGIN

END

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Enum as a parameter in Procedure, how to do it ??
3677
October 01, 2012 01:03AM


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.