inserting into a long data type

From: Time Vest Insurance <reb_at_timevest.com>
Date: 17 Dec 2002 01:46:50 +0000
Message-ID: <l8zel8h8lit.fsf@timevest.com>

I have an existing table FOO

     id   int
     html long

We have been doing

	update FOO 
	set HTMl = 'bunch of long ugly HTML and javascript syntax' 
	where id = 10

It generally works fine. We are now getting failures like:

    Input truncated to 7499 characters
    SP2-0027: Input is too long (> 2499 characters) - line ignored     SQL> SP2-0734: unknown command beginning "0\" alt=\"..."

• rest of line ignored. SQL>

I don't have the access or authority to change the data type from long to BLOB or CLOB or something else. I tried "set long" but it doesn't seem to have an effect. Can I set some other values in sqlplus to make this work?

Bob Received on Mon Dec 16 2002 - 19:46:50 CST