Re: How can I totally capture logoff trigger?

Jeff Chan wrote:
>
> Dear all,
>
> I have initialized some variable when a user logon the database.
> Originally, I decide to destroy such variable during the logoff trigger
> symmetrically. However, I found that under some situations, e.g. close the
> sqlplus window instead of typing disconnect in sqlplus, the logoff trigger
> will not be executed. How can I make my procedure clean so that no memory
> leak problem occur?
>
> Thanks in advance.
>
> Jeff.

It should not be a problem - pmon will (eventually) sort out the mess

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."