Concatenating CLOB's

From: Ralf Becker <rbepfhm_at_netscape.net>
Date: Fri, 9 Aug 2002 18:00:01 +0200
Message-ID: <aj0oq5$1828gj$1@ID-143639.news.dfncis.de>

Hello!

I'am a beginner with sql-programming.
I have a table with two CLOB (Vorspann, Artikel) and want to create a table with the two CLOB where concatenated to one (Text).

So i do somthing in SQLplus
...
create table Message as
select id, job_id, ressort_id, create_date, titel, Vorspann||Artikel as Text , Stat_1, Stat_2, Status
from T_Message;

and get
ORA-00932: .... What is wrong? - What must i do to concatenate CLOB's?

Thanks for your help. Received on Fri Aug 09 2002 - 11:00:01 CDT