Re: how to update a long data type

From: Alisher Yuldashev <>
Date: Thu, 03 Jun 2010 10:54:46 -0400
Message-ID: <>


Can you show your commands that raise the error? The following example works fine.

  v_long long;
  for i in 1..5000
  end loop;
  insert into avail.long_tab values (1,v_long);   for i in 5001..6000
  end loop;
  update avail.long_tab set name=v_long where n=1; end;


Alisher Yuldashev
Senior Oracle DBA

Dba DBA wrote:
> I am not allowed to change some long data types to clobs. I asked and
> was told no. This is pretty old, so when I google it I don't see much.
> I have a table with a long and I need to update that field (I also
> tried inserting the record into a test table). It appears that the
> data I have to update or insert is over 4k and when I do it I get:
> ora-00972 identifier too long.
> When I google that error, it is normally if your column name is too
> long. How did people put large amounts of data into longs? I have not
> used them in years.
> I made a test table and tried to insert it and got the same error.
> DB Version: Also tried it in an DB.

Received on Thu Jun 03 2010 - 09:54:46 CDT

Original text of this message