Name

unimport_clr — This function automatically drops the SQL Type wrappers based on the CLR Reflection API.

Synopsis

any unimport_clr ( in assemblies_vector any ,
in classes_vector any );

Description

This function automatically drops the SQL Type wrappers based on the CLR Reflection API. If there is compiled Virtuoso/PL code that references the type it will fail to execute (with a compilation error) when executed or compiled.

Parameters

assemblies_vector

a vector of assembly names (as VARCHAR) to look into (or null).

classes_vector

a vector of type names to create SQL type wrappers for (or null to mark all the types in the assemblies specified by assemblies_vector. In that case the assemblies_vector cannot be NULL).

Examples

Example24.430.Dropping an imported Class

Now this library must be introduced to the Virtuoso Server. In ISQL use the following commands to test the CLR:

SQL> DB..unimport_clr (vector ('sanity'), vector ('sanity'));

Done. -- 300 msec.
SQL> select sanity::test('Rob');

*** Error 37000: [Virtuoso Driver][Virtuoso Server]UD041: No user defined type DB.DBA.sanity
at line 2 of Top-Level:
select sanity::test('Rob')

See Also

import_clr

The Runtime Hosting Chapter