MySQL Bugs: #11696: Please add CREATE MODULE syntax, or Oracle PACKAGE equivalent

Bug #11696	Please add CREATE MODULE syntax, or Oracle PACKAGE equivalent
Submitted:	1 Jul 2005 23:55	Modified:	23 Aug 2009 10:15
Reporter:	Roland Bouman	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:	5.0.7	OS:	Any (NA)
Assigned to:		CPU Architecture:	Any

Description:
The ISO standard specifies creation of server modules as part of the stored procedure language (iso 9075:1999, 4/psm, 9.18). This would be a great feature if it were implemented somewhere in the future, allowing business logic to be packaged in coherent, maintainable, separately deployable units.

How to repeat:
NA

Suggested fix:
Support server side modules as part of the stored procedure language, or a similar construct.

Changed the title, maybe it's more apealing now.

I would also like to see the functionality similar to Oracle Package space to group stored procedures and functions into logical groupings .  

Providing the SQL Standard has a MODULES syntax, as stated implementation would provide ANSI SQL compliance

It would be a good thing for professional users.

I would like to see a package equivalent in MySql to group related functions and SPs in a logical group.

Bug #3503 was marked as duplicate of this one

Thank you for the reasonable feature request.

i need oracle package equivalent, i think that is a good feature for the progress of mysql.

I would love to see this feature in MySQL as well.

I work at a company using oracle exclusively on multiple databases and distribute them to other parties. One of the biggest reasons for using Oracle is the fact of Packages stored on the database, atleast for us.

We would much rather use MySQL if an Oracle Package equivalent was present.

Yes, this will be a great feature to structure the functions and SP's.

Bug #46739 was marked as a (yet another) duplicate of this one.

This would be very useful. Please consider adding this.

Absolutely! Please let us know when (tentatively in which future versions) the Package concept would be available in MySQL? this would be of real great help.

Yes - I would definitely like to be able to group functions and procedures in a package.

It would be really great to have a package construct in MySql, as most of the people are finding it as a lag in a beautiful DB like this.

Not much activity on this ticket anymore...? But in large database schemata, there may be hundreds of procedures/functions, which should clearly be grouped into packages. Not just will that help organise the logic, but sometimes it is much easier to just GRANT EXECUTION rights to a package, rather than to several procedures.

Also, with Oracle's separation of package specs and body, it is easy to make "private" utility procedures that are not exposed to the whole database.

I would love to implement MySQL package (or module) support in www.jooq.org

Please implement this feature... This is a MAJOR drawback to MySQL

The request is SEVEN years old, and the activity in this bug has been negligible. All I can conclude is this thing is never going to get implemented. In that case, I would like to comment that not having a MODULE concept in a procedural language is an embarrassment. The people who make decisions on what to implement should be ashamed of not even considering this.

Such a bummer! Looks like I won't be able to do use mysql for my project.

Show Stopper! Looks like I won't be able to convert my huge application from  Oracle to Mysql for my project.

It would be a GREAT improvement. Please consider this.

This bug should be closed out.   Package/module construct won't be added to mySQL so long as Oracle is calling the shots.   That would be like shooting themselves in the foot. :)

I don't fully agree, ALEXANDER RANCOURT. Having packages would make organizing lots of functions and procedures very conveniant. There is still a lot in Oracle SQL that's not available in MySQL, so this is not like shooting themselves :P

I think it is necessary. Oracle and mariadb accept PACKAGES just like other environments. This is necessary if we want to be able to belong to multi-environment systems, environment migrations and others...