Re: Execute stored procedure when user connects ?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Fri, 3 Nov 2000 17:43:54 -0000
Message-ID: <8tutk0$pu4$3@lure.pipex.net>

and certainly not on a 7.3.4 database.

rats can't think of an appropriate Floyd reference here.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Walter T Rejuney" <BlueSax_at_Unforgetable.com> wrote in message
news:3A02BD3A.5B119A6C_at_Unforgetable.com...


> "Jürgen Schneider" wrote:

>

> > Hi,

> >

> > is it possible to execute a stored procedure when a user connects to a

> > Oracle database. Is there something like a  startup script that can be

> > edited.

> >

> > Thanks,

> >

> > // Juergen

>

> Create or Replace Trigger trg_after_logon

> After Logon On Database

> Begin

>         raise_application_error(-20101,"Goodbye Cruel World");

> End;

>

> Although probably would not recommend that you actually use my example

> until you thoroughly understand what it would do.

>

>

Received on Fri Nov 03 2000 - 11:43:54 CST