Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    4

    Unanswered: Character conversion error

    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

  2. #2
    Join Date
    May 2003
    Posts
    87

    Re: Character conversion error

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •