CONCAT Long and String

Hello,

I need to update a LONG col. I tried it in this way: UPDATE comp SET field1=CONCAT(field1, 'additional remark') WHERE ckey=4711;

But that construct throws the error ORA-00932. I tried some cast functions but they won't work.

Any idea?

Greetings,
Andreas Received on Sun Mar 09 2003 - 16:44:09 CST