Home » SQL & PL/SQL » Client Tools » character conversion error 24365
character conversion error 24365 [message #25947] Wed, 28 May 2003 05:03 Go to next message
Rami
Messages: 7
Registered: February 2002
Junior Member
Hi,

I have created a table

create table ntest (data nclob);

It took more than 4000 characters(using jbdc program). I checked this
with

select length(data) from ntest;

I got the result: 43876

But when I tried to select the value using the sql plus client
using

select data from ntest;

I got ORA-24365: error in character conversion.

But if I use
select to_nchar(data) from ntest;
or
select to_char(data) from ntest; ;
I am getting 4000 characters only. This is displayed in sql
plus client.

I am trying the same through JDBC programs.
My oracle 9.0.1 server is running in HP-UX machine, weblogic 7.0 server is running in windows 2000. I am accessing the value through weblogic type 2 driver for oracle (oci driver).

Please help to solve the 24365 error

Thanks in advance
rami
Re: character conversion error 24365 [message #25964 is a reply to message #25947] Wed, 28 May 2003 15:21 Go to previous messageGo to next message
Sunny
Messages: 25
Registered: November 2001
Junior Member
Cause: This usually occurs during conversion of a multibyte character data when the source data is abnormally terminated in the middle of a multibyte character.

Action: Make sure that all multibyte character data is properly terminated.
Re: character conversion error 24365 [message #25968 is a reply to message #25964] Wed, 28 May 2003 23:19 Go to previous message
Rami
Messages: 7
Registered: February 2002
Junior Member
Sunny thanks for your reply.
I read this one in the documentation. I make sure that the character data are propertly terminated. But Still I have the same problem. Can you give me anyother ideas.

Thanks in advance.
rami
Previous Topic: Slow about join
Next Topic: HELP
Goto Forum:
  


Current Time: Tue Aug 11 08:50:21 CDT 2020