Forum OpenACS Q&A: Re: NLS_DATE_FORMAT problem with remote Oracle

Collapse
4: Re: NLS_DATE_FORMAT problem with remote Oracle (response to 1)
Posted by Barry Books on 02/26/04 02:57 AM
I always have trouble mixing Unix and NT. This seems to fix the problem 
create or replace trigger data_logon_trigger
after logon
ON DATABASE
begin
    execute immediate
        'alter session set nls_date_format = ''YYYY-MM-DD'' ';
end;
/
show error