Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change the locale for a jasper report that has been called trough utl_http

Nico MartensAug 12 2011 — edited Aug 12 2011
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
This post has been answered by Zulqarnain on Aug 12 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2011
Added on Aug 12 2011
3 comments
1,380 views