| character conversion error 24365 [message #25947] |
Wed, 28 May 2003 05:03  |
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  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
