Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I "totally" capture the logoff trigger?
I have the same problem when I am using external procedure such as OCI or
ProC. Please help!!!!
"Jeff Chan" <jchan_at_issl.com.hk> wrote in message
news:9s8ghq$18145_at_hkunae.hku.hk...
> 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.
>
>
Received on Tue Nov 06 2001 - 05:46:40 CST