# 22. Virtuoso Functions Guide - unimport_clr

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
import_clr
unimport_clr
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## unimport_clr

This function automatically drops the SQL Type wrappers based on the CLR Reflection API.
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
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