List:General Discussion« Previous MessageNext Message »
From:SGreen Date:January 2 2006 7:31pm
Subject:Re: Compiler for Embedded SQl Macros
View as plain text  
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
Thread
Compiler for Embedded SQl MacrosEzhilarasan Sammandam30 Dec
  • Re: Compiler for Embedded SQl MacrosSGreen2 Jan