Print Thread
ORA-24812: character set conversion to or from UCS2 failed
#62847 01/13/22 05:42 PM
Joined: Jul 2002
Posts: 68
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 68
Hi
I am stumbling upon this oracle error: ORA-24812: character set conversion to or from UCS2 failed.
When running the program normaly it works ok.
When starting the program on the same machine connecting to the same database from a windowsservice it is generating this ORA-24812 error.

The failing sql is doing a select on a table with a clob field. somethin like this.

select a.*,
a.rowid,
decode(instr(clobfield, 'searchtext'), 0, 'F', 'J') textfound
from tablename a;

any help is appreciated

kind regards

Ruud

Re: ORA-24812: character set conversion to or from UCS2 failed
Ruudbern #62853 01/17/22 10:01 AM
Joined: Aug 1999
Posts: 21,665
Member
Offline
Member
Joined: Aug 1999
Posts: 21,665
Perhaps you can check if the Oracle environment is the same when running as a service? Specifically the character set of the NLS_LANG environment variable.


Marco Kalter
Allround Automations
Re: ORA-24812: character set conversion to or from UCS2 failed
Marco Kalter #62868 01/20/22 07:15 AM
Joined: Jul 2002
Posts: 68
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 68
Hi Marco,

thanks for your reply.
It turned out to be a wacky instant client installation.
Installilng the full client seems to have fixed the problem.

kind regards
Ruud


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4