Re: Bigger type length than Maximum

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 Mon Aug 24 1998 - 00:00:00 CDT