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;

[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 DD
HH24:MI:SS''');
  return (TRUE);
end; Received on Mon Mar 14 2005 - 21:04:14 CET

Original text of this message