Re: Run stored procedure on logon to oracle 7.3.3.6 database

From: nooruddin <nooruddin76_at_telebot.net>
Date: Mon, 12 Jul 1999 16:05:23 +0530
Message-ID: <7mdkst$5sm$1@news.vsnl.net.in>

Hi i'm nooruddin!
find the file named glogin.sql version 3.3 or 3.1 and then at the end of the file give the command

exec procedure name and that'll solve the probles---i guess

bye...
Michel Lentelink wrote in message <37899e76.0_at_gaspra.oss.akzonobel.nl>...
>Hello,
>
>I would like to execute a stored procedure, whenever someone log's into
the
>database.
>This procedure must be the first to execute.
>The procedure execute's for every user who logs into the database. It
checks
>if the user has already a
>session in the database, if so, he must be rejected with that session.
>
>The check and killing of the session is not the problem. The problem is how
>to execute the stored proecedure (or
>something else) as the first process by logon into the database.
>
>Has anyone the answer to my problem?.
>
>Thanks.
>
>Best regards
>
>michel.lentelink_at_intervet.akzonobel.nl
>
>
>
>
>
Received on Mon Jul 12 1999 - 05:35:23 CDT