Re: NLS parameters in Oracle Reports

[Quoted] Hi Frank;

Thanks for the reply. I'm using 10g. The Reports builder in 10 g is 9.0.4.33. The DB is 9i. My understanding was that if I set the NLS properties, the number, date, and currency fields will be displayed in a mask that is appropriate for that language, providing I haven't set an explicit mask for the field. However, I've seen several threads (many on Oracles discussion board) indicating that other people are also unable to get the Alter Session commands to have any impact on reports. One poster said that the alter statement will work for Forms but not reports.

My goal would be to write one report which would handle multiple languages. The non-data text fields (titles, col headings, etc), I would retrieve from resource files based on the language. However, getting the dates, numbers and currencies (the data) to format with language dependent masks is the other piece to the puzzle. The Oracle documentation seems to indicate that setting the NLS parameters will cause the numbers, dates, and currencies to display in the format based on the NLS parameters.

So, for example, in France, the thousand seperator is a space and the decimal point is a comma. I am hoping that by simply setting the NLS parameters (not in the environment but at runtime in the before report trigger) the numbers will be displayed that way.

Have you successfully used an alter stmt on a report trigger?

I've read that an alternative is to pass the language/territory in on the URL statement to the reports server. However, at this point I don't have a full fledged report server. I am simply using the reports developer installed locally on my machine.

Thanks for your help!
Joe T Received on Mon Mar 14 2005 - 23:27:30 CET