Procedures called from logon and startup database triggers come to mind. I've coded a "10046" set of procedures that uses it to isolate it from the current transaction (obviously). I've also used it to do ancillary application tasks like maintaining user preferences. My $.02, Rich > has anyone found a use for this other than for logging? > 1. doing stuff > 2. log what i am doing. commit it and don't want to commit do stuff > 3. continue doing stuff > > anyone use it for anything else? > -- //www.freelists.org/webpage/oracle-l