Name
connection_set — Associates a value to the name in the context of the present connection
Synopsis
connection_set ( |
in name varchar , |
in value any ); |
Description
This associates a value to the name in the context of present connection. The name should be a string and the value can be any data type except blob, open cursor or an XML entity. If the value is an array it may not contain the restricted types.
Connection variable setting is not logged and information stored will be lost when the connection is closed. The value can be retrieved by any future statement executing within the same connection. Connection variables can be used as a global variable mechanism for stored procedures, the scope being the client connection.
In the case of VSP or SOAP this mechanism cannot be used to pass information between requests by the same client. It will however, be useful for having 'global variables' between procedures called within the same HTTP request. Note that this mechanism is used to provide persistent HTTP session variables in some cases but this works through special before and after code which stores the values set with this function into an external session structure. In this sense this function itself has nothing to do with web session management although it can be used as a component for such.
Parameters
name
VARCHAR name to associate the value with.
value
value
to be stored. May
be any data type except LOB , open cursor
or XML entity. If the value is an array ,
it may not contain the restricted types.
Return Values
None
Errors
Table24.16.Errors signalled by connection_set
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 22023 | SR049 | Data type is not suitable for storage into a global variable (connection_set) |
Examples
Example24.51.Setting and Retrieving Connection Variables
From SQL
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
From a VSP page
<?vsp
declare id integer;
id := 12;
connection_set ('ID', id);
connection_set ('saved_request' , lines);
?>