CLOB/NCLOB help needed please.
Date: Fri, 21 Nov 2003 11:04:17 -0600
Message-ID: <3fbe4a4b$1_at_news.splitrock.net>
Hello,
I am having trouble moving data from a CLOB to a NCLOB column.
My current table structure for table fmattachmentembed:
New structure desired:
Now when I execute the insert statement, below, to move the existing data
into the new table structure the
Any ideas on how to fix this?
Insert Statement to move the data:
FROM fmattachmentembed
Drop the old table:
fmattachmentid number(10,0) not null,
fmvalue clob null,
fmextension varchar2(4) null,
fmsize number(8,0) null
CREATE TABLE xxattachmentembed (
fmattachmentid number(10,0) not null,
fmvalue nclob null,
fmextension nvarchar2(4) null,
fmsize number(8,0) null )
following error is encountered: "ORA-01482: unsupported character set".
INSERT /* APPEND */ INTO xxattachmentembed nologging
SELECT fmattachmentid
,Translate(fmvalue USING NVARCHAR_CS )
,fmextension
,fmsize
/
DROP TABLE fmattachmentembed
/
RENAME xxAttachmentEmbed TO fmAttachmentEmbed
/
Thanks,
Rob Panosh
Advanced Software Designs
Received on Fri Nov 21 2003 - 18:04:17 CET