Re: nls_date_language in reports !!

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Fri, 18 May 2001 19:27:03 GMT
Message-ID: <3b0576ab.21383317@news.online.de>

alter session set NLS_LANGUAGE='Dutch'
select to_char(sysdate,'DD.MON.YY') as datum from dual

DATUM

---

18.MEI.01 Is this not working for you ?

Ted

On Wed, 16 May 2001 19:39:19 +0200, "Mo" <jhj_at_blabla.com> wrote:

>I try to get a Dutch date language as output of a report so
>I write a before report triger like this :
>function BeforeReport return boolean is
>begin
>SRW.DO_SQL ('ALTER SESSION
>SET nls_date_language = DUTCH');
>return (TRUE);
>end;
>
>but when I run the report I still get the English date instead of the Dutch
>!!
>
>the language of my oracle 7.3.4 is English any idea folks ???
>
>thanks, Mo.
>
>
>
>
>

EMail: knijff_at_bigfoot.com Received on Fri May 18 2001 - 14:27:03 CDT