MONTHNAME just in local language

Question

Hi all,

does anybody know how OBI determines what output language to use for function MONTHNAME. It gives me results only in czech. Even I set my account to english and also the browser but no luck. Also in other countries they see czech names what points me to the db which is the only common thing. Any idea?

Thanks

Petr

[Deleted User] · Answer

You gotta check out what's populated for your users. USERLOCALE or WEBLANGUAGE

Boček Petr · Answer

Question is how. I would use the alter session command linked to a variable but I'm not sure how to fill the variable with value of current locale... Is it LOCALE? But what init block to use?

[Deleted User] · Answer

It's function-shipped to the DB I assume ("assume" because obviously OBIS can't ship that to all sources and for some does it internally) which is why the DB wins. So you need to pass the LANG settings to the DB depending on the user's profile.