Help! Updating a LONG column

Problem updating a column of type LONG

I have a table called USERS.
One of the columns of the USERS table is called WORK_SQL and is of type LONG, where a LONG stores a character string up to 65535 in length.

I am not able to UPDATE the WORK_SQL column.

Is there anything wrong with the following SQL statement:

UPDATE USERS SET WORK_SQL = '---255 characters' || '--255 characters' || .....

        WHERE USER_ID = 'ABC' where "||" is the string concatenation operator.

No error is returned, but only the first 255 characters are copied to the column.

Many thanks.

Neil Watson.
neilw_at_peregrine.ie Received on Thu Nov 02 1995 - 00:00:00 CET