Re: Bigger type length than Maximum

I think this problem occurs when one of the rows returned in the query has a field that has exactly 254 chars. It also occurs with 509 chars.

Try selecting from the table where strlen(fldname) = 254 and see if it returns any rows.
If so, delete the row, and then run your java app again to see if it works.

What version of the JDBC drivers are you using? The lastest JDBC drivers from Oracle solve the problem

Hope this helps

Regards,
Mick

Andreas Huber wrote:

> Paul, dx(?),
>
> finally I found at least somebody who is experiencing the same problem I
> have been struggling with for a while now.
>
> Trouble is: I have no stable scenario to reproduce this error. Somethimes on
> the same table it will happen with one ORDER BY clause and work well without
> any or with another ORDER BY.
>
> Currently we investigate the hypothesis that the error might be caused by
> <cr><lf> pairs in VARCHAR2 fields, I will let you know how it goes.
>
> Trouble is: we are not really successful with the JDBC/ODBC bridge either
> (we could use it since we write server side Java, not Applets).
> - the Oracle ODBC driver gives me trouble with INSERT (judging from the ODBC
> trace it appends a literal "\ 0" (not a null character, but this very
> sequence) to each and every statement
> - the MS version is building up memory at a rate of 1 MB per 10 minutes in
> IIS so it will only run a couple of hours before terminating due to lack of
> memory
> - the JDBC thin driver has these strange errors
> - we cannot use the OCI7 version since it will not run in the MS Java engine
> I am rather new to Oracle (we used to work with DB2) but I am not really
> impressed with these results.
>
> Do you have any experience you are willing to share?
>
> Andreas
>
> Paul Brown wrote in message <35deeffb.468826887_at_news.demon.co.uk>...
> >Does anyone know of a way around this error message, or what causes it
> >in the first place, when using the Oracle JDBC drivers ?
> >
> >Thanks for any help
> >
> >Paul Brown
Received on Wed Sep 02 1998 - 00:00:00 CDT