update long column [message #35694] |
Sat, 06 October 2001 00:36 |
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 |
audrey
Messages: 3 Registered: October 2001
|
Junior Member |
|
|
try using clob...
and dbms_lob to manipulate the data...
----------------------------------------------------------------------
|
|
|