WL#2346: External Language Plugin: CLR
Affects: 9.x
—
Status: Un-Assigned
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, 2025, Oracle Corporation and/or its affiliates. All rights reserved.