Re: Please assist with database event trigger

Thanks, this did the trick. I guess my problem was the PL/SQL book I was referencing covered version 7-8i and simply stated that the dbms_sql.execute was not necessary.

The execute immediate works beautifully and is much more straight forward.

--
Dave A


"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:973062129.1295.3.pluto.d4ee154e_at_news.demon.nl...


> IIRC, DDL-statements needs a dbms_sql.execute (not necessary in 7.3 and

 8.0)


> However, as you are using 8i, why don't you replace the dbms_sql calls

 with


> one

> execute immediate 'alter session set nls_date_format=''DD-MON-YYYY'' ';

>

> Hth,

>

> Sybrand Bakker, Oracle DBA

>

> "Dave A" <dave_and_vanna_at_hotmail.com> wrote in message

> news:svuq27fke53ie2_at_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

> >

> >

> >

> >

>

>