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

Try this:

Right-click on the table in the object tree that contains the LONG
column and choose "Limit cell edit WHERE clause size".  In the dialog
that pops up, move the LONG column to the "Not Use Columns", using the
=> arrow.  Click OK.  Try to update the row again.

Oracle does not allow LONG columns to be used in WHERE clauses.
Please file a bug report for this problem here:

http://sourceforge.net/tracker/?atid=393414&group_id=28383


Rob


On 9/19/07, Dwight Fromm <dwight@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?
>
> Thanks for any help, ~Dwight
>
>
> -------------------------------------------------------------------------
> 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/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

-------------------------------------------------------------------------
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/