Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Error: String Literal to long?

Re: ODBC Error: String Literal to long?

From: Richard Grover <grover_at_gdt-inc.com>
Date: Tue, 07 Sep 1999 08:26:52 -0700
Message-ID: <37D52EBB.3883A0CB@gdt-inc.com>


I am experiencing a similar problem with JDBC/ODBC to oracle 7 storing a large string into a LONG field...what I've read in the doc's seems to indicate that this is due to a buffer sizing issue...but what buffer and how to size it escapes me?

Rich G.


Chris Bos wrote:

> Hi,
>
> whenever I try to insert a string that is larger than 2000 characters into
> an oracle LONG field via ODBC I get an eror telling me the string literal is
> to long.. can anyone explain the why and possible solution to me? I am using
> oracle 7.3 on NT and VB to do the inserts.
>
> Thanks
> Chris Bos
Received on Tue Sep 07 1999 - 10:26:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US