SQL & PL/SQL

Anyone,

I am trying to concatenate a string together in a stored proc that is longer then 4000 charcaters. The value is going into a LONG column so the col will take it but the proc itself will not allow me to put the string together.

I stopped using a var and instead try doing concat inside the UPDATE satement and I still get the value to large error ORA-01489.

Can anyone tell how to do this? Here is my current statement:

SELECT LDTEXT
       INTO var_LDTEXT
       FROM MAXIMO.LONGDESCRIPTION
       WHERE LDKEY = var_ldkey_new ;

UPDATE MAXIMO.LONGDESCRIPTION
SET LDTEXT = (SELECT var_LDTEXT || rec.LDTEXT FROM DUAL)
WHERE LDKEY = var_ldkey_new