Updating LONG data type columns

From: Dave Pylatuk <davep_at_centurysystems.net>
Date: Tue, 18 Nov 2003 14:47:17 -0500
Message-ID: <XGuub.9213$iT4.991931@news20.bellglobal.com>

Hello all. I have a question about updating a LONG datatype column in Oracle 8.1.7.

I have a STUDENT table like:

student_id                INTEGER PK

student_comments LONG

I want to execute a command like this:

UPDATE student SET student_comments = student_comments || 'some new comments' WHERE student_id = 1;

I am getting an error message indicating incompatible data types. Do I have to do some sort of conversion/cast to add my new comments to the existing ones ?

Thanks in advance Received on Tue Nov 18 2003 - 13:47:17 CST