[rameshmanickam]

Hi,

I have created a table

<b>create table ntest (data nclob);</b>

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 <b>ORA-24365: error in character conversion.</b>

But if I use
<b> select to_nchar(data) from ntest;</b>
or
<b> select to_char(data) from ntest; ;</b>
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).

<b> Please help to solve the 24365 error </b>

<b> Thanks in advance </b>
rami

[dbmadcap]

Try changing the column name from "data" to something else and that will get rid of your problem.

HTH !

Originally posted by rameshmanickam
Hi,

I have created a table

<b>create table ntest (data nclob);</b>

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 <b>ORA-24365: error in character conversion.</b>

But if I use
<b> select to_nchar(data) from ntest;</b>
or
<b> select to_char(data) from ntest; ;</b>
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).

<b> Please help to solve the 24365 error </b>

<b> Thanks in advance </b>
rami