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.
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.