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