Re: Problem with varchar2 datatype in Oracle

From: <karsten_schmidt8891_at_my-deja.com>
Date: Thu, 06 Jan 2000 14:09:38 GMT
Message-ID: <8527mp$qgn$1@nnrp1.deja.com>

Hi,
what kind of jdbc interface are you using ? there used to be a 2000 limit in Oracle 7, perhaps you are going through an Oracle 7 jdbc driver that does not allow more than 2000 characters.

Karsten

In article <850jau$m8a$1_at_nnrp1.deja.com>, Ravindra B <ravi_m_at_my-deja.com> wrote:
> Hi,
> I had created a table which contains a column of type
> varchar2(4000). When I am trying to insert through Java code into the
> column using method setString, it works fine when the size of the
string
> being inserted is less than 2000 in size, if it is more than 2000 then
> it gives me an SQLException.
> I tried manually(i..e.. using SQL Plus) and it works fine.
>
> Can anyone help me out, why this problem is occurring.
>
> Thanks in advance.
>
> Ravi.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 08:09:38 CST