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

Collapse
Posted by Barry Books on
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