All,
When we call the utl_http package to generate a jasper report within oracle and save it as a blob the default language (nls_language and nls_territory) gets overwritten by AMERICAN/AMERICA.
This gives problems with comma's and points as decimal separator...
As far is I know it is not possible to change the language within jasper server.
I suspect that utl_http creates a virtual browser with a default language (AMERICAN) this gets inherited by jasper server. Is there a way to change this language???
I already tried
execute immediate ('alter session set nls_language= ''DUTCH'' nls_territory= ''BELGIUM'' nls_numeric_characters='',.''');
This did not work!!!
The work around for now is to change the format mask within the query of my jasper report but then we can no longer do aggregation functions.
All help is greatly appreciated...
Thnx