Re: CONCAT Long and String

Andreas Schlegel wrote:

> 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

Had you given us a version and edition of Oracle I'd not do this ... but as you didn't ... go to http://tahiti.oracle.com and look up LONG data type. You'll not be doing this in SQL.

And it would be best to migrate to CLOB datatype.

Daniel Morgan Received on Sun Mar 09 2003 - 18:45:04 CST