OraFAQ Forum: Server Administration » I need to write to a table.

Home » RDBMS Server » Server Administration » I need to write to a table.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I need to write to a table. [message #369810]

Tue, 17 October 2000 11:48

Luis Gabriel
Messages: 11
Registered: October 2000

Junior Member

Hi,

I need to write to a table when somebody connects to oracle (I have oracle 7.3.2) and erase this record when
the user disconnects from oracle.

Can somebody help me please?'

Tanks.

Report message to a moderator

Re: I need to write to a table. [message #369811 is a reply to message #369810]

Tue, 17 October 2000 13:14

Christian Boulet
Messages: 9
Registered: April 2000

Junior Member

Hello,

I would suggest that you add your insert statement in the file

glogin.sql
located in the ORACLE_HOME/sqlplus folder of every workstation...

Report message to a moderator

Re: I need to write to a table. [message #369817 is a reply to message #369810]

Wed, 18 October 2000 02:48

Venkatramanan
Messages: 10
Registered: October 2000

Junior Member

Hi Chris,

U can write a trigger like this :

CREATE OR REPLACE TRIGGER <name> AFTER LOGON
ON DATABASE
BEGIN
<insert into table statement>
END;

CREATE OR REPLACE TRIGGER <name> BEFORE LOGOFF
ON DATABASE
BEGIN
<delete from table statement>
END;

Venkatramanan.

Report message to a moderator

Previous Topic:	Tab setting in forms 6.0
Next Topic:	I need your help about encrypt and decrypt of credit card

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 07:33:10 CDT 2024