Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there any equivalent for packages (Oracle) in MySQL

Tags:

mysql

oracle

I'm converting procedures from Oracle to MySQL. Is there any feature like packages in MySQL ? If it is not there, what is the substitute for packages in MySQL ?

like image 914
Svathi Avatar asked Mar 14 '11 09:03

Svathi


2 Answers

Unfortunately there is no equivalent AFAIK.

See this MySQL bug : Bug #11696 - Please add CREATE MODULE syntax, or Oracle PACKAGE equivalent

like image 80
Frosty Z Avatar answered Sep 20 '22 13:09

Frosty Z


Mysql supports stored procedures - the namespace of this is at the database level - there is no explicit support for creating namespaces at a lower level, and the '.' scope operator seeprates databases and objects.

So there is no equivalent entity in MySQL to an Oracle package.

like image 25
symcbean Avatar answered Sep 21 '22 13:09

symcbean