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

Robert Manning wrote:
> 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.

Oooh, that does help out. I was able to make a successful test edit now. Yea! 
I will look further for a >4000 char data values to edit and see how that goes 
as well.

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

I'll check it out.

Thanks! ~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/