NLS parameters in Oracle Reports
From: <joet11_at_comcast.net>
Date: 14 Mar 2005 12:04:14 -0800
Message-ID: <1110830654.416748.220390_at_g14g2000cwa.googlegroups.com>
Hi;
return (TRUE);
end; Received on Mon Mar 14 2005 - 21:04:14 CET
Date: 14 Mar 2005 12:04:14 -0800
Message-ID: <1110830654.416748.220390_at_g14g2000cwa.googlegroups.com>
Hi;
[Quoted] The Oracle documentation seems to be saying that if you would like to modify language/territory (i.e. NLS) parameters, for a report, at runtime, you can issue 'Alter Session' statements in a before report trigger.
I have tried several alter session statements in the before report trigger but they have no effect on how my data is displayed. Any ideas as to what I'm doing wrong? Here is my before trigger:
Thanks - Joe T
function BeforeReport return boolean is
begin
SRW.DO_SQL ('ALTER SESSION SET NLS_ISO_CURRENCY = FRANCE'); SRW.DO_SQL ('ALTER SESSION SET NLS_DATE_LANGUAGE = French'); SRW.DO_SQL ('ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '',.'''); SRW.DO_SQL ('ALTER SESSION SET NLS_DATE_FORMAT = ''YYYY MM DDHH24:MI:SS''');
return (TRUE);
end; Received on Mon Mar 14 2005 - 21:04:14 CET