Ezhilarasan Sammandam <ezhilarasan@stripped> wrote on 12/30/2005 08:53:36
AM:
> Hi,
>
> Is there any compiler to Compile Embedded SQL Macros into source codes
> for MySql?
> In otherwords, what is the equivalent of PRO*C (in Oracle) in MySql?
>
> Thanks,
> Ezhilarasan
STORED PROCEDURES and FUNCTIONS are part of V5.x.
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
Before that you can compile your own functions (also known as User
Defined Functions) by following the directions in the manual. These are
actually compiled modules that you load into the running server or
physical extensions that become part of the server itslef (they call these
"native functions")
Full details: http://dev.mysql.com/doc/refman/4.1/en/adding-functions.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
