Re: NLS_DATE and WebDB

try the DBMS_SESSION package
Greg <actiris_at_loxinfo.co.th> schreef in berichtnieuws 3961623B.5409943B_at_loxinfo.co.th...
> Dear Tim
> the trigger
>
> create or replace
> trigger WEBDB.TR_DATA_LOGON
> after logon
> on DATABASE
> begin
> execute immediate
> 'alter session set nls_date_format = ''dd.mm.yyyy'' ';
> end;
>
> works on SQL Plus
> but not in WebDB.....Forms
>
> any oher tips
> greg
> >At 11:44 19.06.2000 +0000, you wrote:
> >see
> >http://govt.oracle.com/~tkyte/
> >
> >if your are on 8i, you can use a database trigger.
> >
> >HTH,
> >Tim
> >>
> >>
> >>Like to change the default Date
> >>from
> >>dd-mmm-yy to
> >>dd.mm.yyyy hh24:mi
> >>
> >>in Windows NT 4.0, Oracle 8i
> >>
> >>The Key NLS_DATE
> >>is not present in the Registry
> >>
> >>Where I have to set it.
> >>
> >>I have HKLM\SW\ORACLE
> >>
> >>HOME0 and HOME1
> >>and
> >>ALL_HOMES\ID0 and ID1
> >>
> >>Thanks Greg
>
Received on Sat Jul 29 2000 - 00:00:00 CEST