connection_is_dirty — check if current session connection variables have been altered


integer connection_is_dirty ( );


This function is used to determine if the session variables have changed between a call to connection_vars_set and current point of execution. A call to connection_vars_set will cause subsequent calls to connection_is_dirty to return true.

The function is useful in postprocessing functions for making conditional storage of session variables in a database table.

Return Values

An INTEGER indicating true (1) or false (0).


Example 24.50. Checking Connection Variables

    declare rc integer;
    connection_vars_set ();
    rc := connection_is_dirty (); -- rc is equal to 0
    connection_set ('ID', 14);
    rc := connection_is_dirty (); -- rc is equal to 1