Top

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

Example 24.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