Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I "totally" capture the logoff trigger?

Re: How can I "totally" capture the logoff trigger?

From: wing chun <wchun>
Date: Tue, 6 Nov 2001 19:46:40 +0800
Message-ID: <9s8iit$16pa1@hkunae.hku.hk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US