Re: Help! Updating a LONG column

Neil Watson <neilw_at_peregrine.ie> wrote:

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

Neil,

   You MUST set long to on in Sqlplus or it will always convert it to a varchar2 255.

Hope this helps. Received on Thu Nov 02 1995 - 00:00:00 CET