Home » SQL & PL/SQL » SQL & PL/SQL » update long column
update long column [message #35694] Sat, 06 October 2001 00:36 Go to next message
Peter
Messages: 62
Registered: August 2000
Member
Oracle 7.3.4, PL/SQL
I want to update a LONG column on a table ( 2 G )
I cannot find a PL/SQL type capable of storing the LONG information I want to write, the "long" PL/SQL type being limited to 32K
I cannot either write progressively by concatenation in the LONG columns (e.g. this does not work update
set LONG_COLUMN = LONG_COLUMN || var_plsql_long where ... - in a loop)

What Can I do ?
is there a way to append information to a LONG ?
or ... ?

----------------------------------------------------------------------
Re: update long column [message #35710 is a reply to message #35694] Mon, 08 October 2001 23:57 Go to previous message
audrey
Messages: 3
Registered: October 2001
Junior Member
try using clob...
and dbms_lob to manipulate the data...

----------------------------------------------------------------------
Previous Topic: Compilation error
Next Topic: Unix from Stored Procedure
Goto Forum:
  


Current Time: Thu Mar 28 16:00:56 CDT 2024