Re: Execute stored procedure when user connects ?

"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 - 07:27:22 CST