# 22. Virtuoso Functions Guide - udt_set

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
import_jar
internal_to_sql_type
internal_type
internal_type_name
isarray
isbinary
isblob
isdouble
isentity
isfloat
isinteger
isnull
isnumeric
isstring
iszero
jvm_ref_import
make_string
sign
stringdate
stringtime
udt_defines_field
udt_get
udt_implements_metho...
udt_instance_of
udt_set
unimport_jar
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## udt_set

udt_set (in udt_inst any, in member_name varchar, in new_value any);
Description

This copies the instance udt_inst, sets new_value to the member with a name equal to the value of member_name (if any) and returns the modified instance copy. This is a functional equivalent of a member mutator.

Parameters
udt_inst – A user defined type instance
member_name – The name of the requested member
new_value – The new value to be set
Return Types

A modified copy of udt_inst with the_value set for member_name.

Examples
Setting user defined type member values

This sample code block shows a user defined type member's value being set.

    ....
    declare inst SER_UDT;

    inst := new SER_UDT ();
    inst := udt_set (inst, 'A', 30);
    return inst.A;
    ....

See Also

udt_get()

udt_defines_field()

udt_instance_of()

udt_implements_method()