Re: CONCAT Long and String

From: Andreas Schlegel <schlegelaw_at_epost.de>
Date: Mon, 10 Mar 2003 19:15:05 +0100
Message-ID: <3E6CD629.6030207@epost.de>

DA Morgan wrote:
> Andreas Schlegel wrote:

>>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.

>
>
> Had you given us a version and edition of Oracle I'd not do this
Sorry. Here are the information:
8i Rel. 2 (8.1.6), W2K, Standard Ed.

... 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.
... and then - how do I cast from a String to CLOB?

Thanks for your help.

• Andreas

Received on Mon Mar 10 2003 - 12:15:05 CST