1: procedure sec_rotate_last_visit(
2: v_browser_id IN sec_browser_properties.browser_id%TYPE,
3: v_time IN integer
4: ) is
5: pragma autonomous_transaction;
6: begin
7: delete from sec_browser_properties
8: where browser_id = v_browser_id and module = 'acs' and property_name = 'second_to_last_visit';
9: update sec_browser_properties
10: set property_name = 'second_to_last_visit'
11: where module = 'acs' and property_name = 'last_visit' and browser_id = v_browser_id;
12: insert into sec_browser_properties(browser_id, module, property_name, property_value, secure_p)
13: values(v_browser_id, 'acs', 'last_visit', to_char(v_time), 'f');
14: commit;
15: end;
|