Re: NLS_DATE and WebDB

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
[Quoted] 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 Tue Jul 04 2000 - 00:00:00 CEST