Name

connection_get — Get connection variable

Synopsis

any connection_get ( in name varchar );

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.

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.

Examples

Example24.48.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