Re: Please assist with database event trigger

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
>
>
>
>
Received on Wed Nov 01 2000 - 00:07:25 CST