Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nls_date_language in reports!!!
"Mo" <jhj_at_blabla.com> wrote in message
news:9duds0$1mj4$1_at_scavenger.euro.net...
> 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.
>
>
>
>
>
Try setting nls_date_language in hkey\local_machine\software\oracle
Your do_sql may start a second process.
Hth,
Sybrand Bakker, Oracle DBA Received on Wed May 16 2001 - 13:28:29 CDT