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
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
__any_grants
close
collation_define
complete_table_name
delay
end_result
exec
exec_metadata
exec_next
exec_result
exec_result_names
exec_score
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 & Internet
XML
XPATH & XQUERY

Functions Index

registry_remove

Remove a variable 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