# 22. Virtuoso Functions Guide - registry_remove

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
__any_grants
close
collation_define
complete_table_name
delay
end_result
exec
exec_next
exec_result
exec_result_names
identity_value
name_part
registry_get
registry_get_all
registry_name_is_pro...
registry_remove
registry_set
result
result_names
row_count
sequence_get_all
sequence_next
sequence_remove
sequence_set
set_identity_column
set_row_count
set_user_id
signal
sinv_create_inverse
sinv_create_key_mapp...
sinv_drop_inverse
sys_stat_analyze
sys_stat_histogram
table_drop_policy
table_set_policy
username
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## registry_remove

Remove a vriable from registry
registry_remove (in name varchar);
Description

The function removes a given variable from registry, so future calls of registry_get returns zero.

Some registry variables are used solely by internal server routines so they should not be changed by any application. Nobody can remove such a "protected" variable even if some of them can be updated by DBA.

Parameters
name – Name of variable to be removed.
Return Types

The function returns the last saved value of a variable or zero if the specified variable does not exists.

Errors

SQLState | Error Code | Error Text | Description
--- | --- | --- | ---
22023 | SR014 | Function registry_remove needs a string as argument 1, not an arg of [datatype] |
42000 | SR485 | Function registry_remove can not remove protected registry variable [name]. |

Examples
Creation and Removal of a Registry Variable

This sequence of operations demonstrates that registry_remove reverts the effect of registry_set.

    > select registry_get ('my_variable');
    0

    > select registry_set ('my_variable', 'my_value');
    1

    > select registry_get ('my_variable');
    my_value

    > select registry_remove ('my_variable');
    my_value

    > select registry_get ('my_variable');
    0

See Also

registry_set

registry_get

registry_name_is_protected

registry_get_all

sequence_get_all

sequence_next

sequence_set

sequence_remove