Hi Thank You very much. As I mentioned I need temp tables for storing "sesssion variables". I plan to write functions to return suitable column value and I need them to be availabele during whole session. That makes deleteing on commit not the best solution. For example I want to keep emp_id in one of columns and use ps_get_emp_id() function to return it's value in other functions. All values stored in thie "parameter" temp table are quite stable. Anyway thank You very much. fisher ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)