Print Thread
ORA-24812: character set conversion to or from UCS2 failed
#62847 01/13/22 05:42 PM
Joined: Jul 2002
Posts: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
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: 22,104
Member
Offline
Member
Joined: Aug 1999
Posts: 22,104
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: 71
R
Member
OP Offline
Member
R
Joined: Jul 2002
Posts: 71
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
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 14 (0.008s) Memory: 2.5015 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-02-25 13:13:45 UTC
Valid HTML 5 and Valid CSS