# 22. Virtuoso Functions Guide - connection_get

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
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
dav add & update fun...
dav manipulation fun...
dav search functions
dav_exp
lfs_exp
serv_queue_top
vhost_define
vhost_remove
webdav users & group...
client_attr
connection_get
connection_id
connection_is_dirty
connection_set
connection_vars
connection_vars_set
dbname
ftp_get
ftp_ls
ftp_put
get_certificate_info
get_keyword
get_keyword_ucase
http
http_acl_get
http_body_read
http_client
http_client_ip
http_debug_log
http_enable_gz
http_file
http_flush
http_get
http_header
http_header_get
http_kill
http_listen_host
http_map_get
http_map_table
http_param
http_path
http_pending_req
http_physical_path
http_proxy
http_request_get
http_request_header
http_request_status
http_rewrite
http_root
http_url
http_value
http_xslt
ses_connect
ses_disconnect
ses_read_line
ses_write
tcpip_gethostbyaddr
tcpip_gethostbyname
vsp_calculate_digest
wsdl_import_udt
XML
XPATH & XQUERY
Functions Index

## connection_get

Get connection variable
any connection_get (in name varchar);
Parameters
name – Name of the connection variable
Return Values

A value associated to the connection by connection_set in the datatype of the original value. If the variable does not exist, a NULL is returned.

Description

connection_get is used to retrieve values stored within the current connection context. See connection_set for a more detailed discussion of connection variables.

Examples
Setting and Retrieving Connection Variables

    SQL> select connection_get('var_demo');
    callret
    VARCHAR
    __________________________________________________________________

    NULL

    SQL> connection_set('var_demo', 'some arb data');

    SQL> select connection_get('var_demo');
    callret
    VARCHAR
    __________________________________________________________________

    some arb data

In a VSP page...

      <?vsp
        declare id integer;
        declare saved_req any;
        id := connection_get ('ID');
        saved_req := connection_set ('saved_request');
      ?>

See Also

connection_set