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 -> Please assist with database event trigger

Please assist with database event trigger

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Tue, 31 Oct 2000 18:53:33 -0600
Message-ID: <svuq27fke53ie2@corp.supernews.com>

Hi all,

Been banging my head out trying to get this trigger to work. Oracle version is 8.1.6.2 on Solaris 2.6

The trigger is valid, it simply does not alter the session like it is supposed to. Can anyone point me in the right direction?

CREATE OR REPLACE TRIGGER aradmin.logon_trigger AFTER LOGON on database
DECLARE
cur1id integer;
BEGIN
IF LOGIN_USER ='ARADMIN' THEN
cur1id:=dbms_sql.open_cursor;
dbms_sql.parse (cur1id,'alter session set nls_date_format=''DD-MON-YYYY'' ' ,dbms_sql.native);
dbms_sql.close_cursor(cur1id);
END IF;
END;
/

TIA,

--
Dave A
Received on Tue Oct 31 2000 - 18:53:33 CST

Original text of this message

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