Why OracleException returns distorting the message?

Question

Why OracleException returns distorting the message?

Hi all.

There is a client application that runs in Orlovoj database.
Everything works, but there is a caveat. When an error occurs receive such

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-24381: ?????? ? ??????? DML
ORA-12899: ???????? ??? ??????? "TEST"."MYBD"."NAME" ??????? ?????? (???????????: 27, ????????????: 22)

Yes, of course, getting ORA-12899, you can guess what the problem was.
But still want to have normal performance.
Tried to play with NLS_LANG, set EnvVar to the value as AMERICAN_AMERICA.CL8MSWIN1251, did not help.

If you have ideas, tell me.
Thanks in advance.

Celestino asked July 9th 19 at 13:34

More answers about "Why OracleException returns distorting the message?"

1 answer

Zoie_Weima answered on · Answer 1 · 2019-07-09T13:36:18.590Z

Zoie_Weima answered on July 9th 19 at 13:36

Application settings? Forced change NLS_LANG in a non-AMERICAN?

On Oracle support to read Doc ID 985974.1 - Zoie_Weima commented on July 9th 19 at 13:39

And you can read more, are you talking about? I do not understand your comment.

The database has the following data:
SELECT * FROM NLS_DATABASE_PARAMETERS
NLS_LANGUAGE - AMERICAN
NLS_TERRITORY - AMERICA

SELECT * FROM NLS_SESSION_PARAMETERS
NLS_LANGUAGE - ENGLISH
NLS_TERRITORY UNITED - KINGDOM

Windows is running the client, English, Russian locale.

And could you give a link to Doc ID 985974.1, immediately not found. - Celestino commented on July 9th 19 at 13:42

:
https://support.oracle.com/epmos/faces/DocumentDis...

I mean that the app can tell within their own session
alter session set nls_lang="other-language";
and errors will be in that language.

If the support does not have access, here comrade recounts the Doc:
oradbastuff.blogspot.ru/2010/10/how-to-change-lang... - Zoie_Weima commented on July 9th 19 at 13:45