WL#2346: External Language Plugin: CLR

Affects: 9.x   —   Status: Un-Assigned   —   Priority: Medium

Work with Eric to develop a set of server requirements for developing external
language support for stored procedures.

LANGUAGE CLR  
------------  
  
There will be CLR (common language runtime) support in  
SQL Server 2005, and IBM is already publishing DB2 examples like:  
  
"  
CREATE PROCEDURE insertSale ( IN empID CHAR(6),  
                              IN custName VARCHAR(60),  
                              IN sale DECIMAL (10,2))  
LANGUAGE CLR  
PARAMETER STYLE GENERAL  
EXTERNAL NAME 'insertSale.dll:bizLogic.salesOps!insertSale';  
"  
  
Notice that here the source code is not inside the database,  
instead it is in a DLL.  
  
So C# and other .NET languages are viable options.  
Notably, Visual Perl and Visual Python (activestate.com)  
are probably viable, in which case we have to ask whether  
MyPerl and MyPHP are necessary when MySQL has CLR support.