Re: How to insert a large value into a LONG column in Oracle

On 9/19/07, Dwight W. Fromm <dfromm@xxxxxxxxxxxx> wrote:
> In my attempts to use the popup editor to update the value of a LONG datatype
> column in Oracle, I get an "ORA-01704 String literal too long" if the data is
> over 4000 chars and if its less than 4000 I get "ORA-00997: illegal use of
> LONG datatype". I can successfully update the long using a SQL update
> statement with a single quoted string < 4000 chars.
>
> I am using version 2.5.1. Is there any way I get squirrel to update a LONG
> column value using the popup editor?

I think we found that SQuirreL attempts to use the LONG column in the
WHERE clause for the update and that this is not valid on Oracle.  I
gave you steps to take to tell SQuirreL not to use that column in the
update, and asked you to file a bug.  This message seems to be a
re-post of the same message from you a few days ago.  Has anything
changed with regard to this bug?  Is the work-around I gave you no
longer working?

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/