Re: SQL Exception: Bigger type length than Maximum

Amit Pradhan <amitp_at_ix.netcom.com> writes:

> I'm running a single query in the servlet that looks something
> like:

....
> I use the OracleStatement class to define types of the
> columns (they are all VARCHAR2(255)) upfront, to avoid 2
> roundtrips to the database.

....
> If the number of rows exceeds 180, (ie. if I change the
> where clause & use " t1.c1 like 'b%' " which has about
> 363 rows) the SQL Exception message shows up:
>
> "Bigger type length than Maximum"
>
> Vendor code in the exception is 0.
>

I would theorize that one of the underlying columns is *not* a varchar2(255), but something bigger and when you broaden the search criterion, you get a row that actually has more than 255 characters in that column.

Just a guess,
M. Received on Thu Jul 22 1999 - 11:00:49 CDT