connection_set — Associates a value to the name in the context of the present connection
||in name varchar ,|
|in value any
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.
VARCHAR name to associate the value with.
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.
Table 24.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)|
Example 24.51. 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
From a VSP page
<?vsp declare id integer; id := 12; connection_set ('ID', id); connection_set ('saved_request' , lines); ?>