sos啊！

jryang

在页面中怎么解决在textarea中填写信息报“处理 CLOB 数据类型时出错”的错误阿！

snow.lovers

改改这个字段的数据类型测试一下看看

dengxiaobao

--1、备份dummy_table中dumy_crypto列的数据

create table dummy_table_temp as select * from dummy_table;


--2、删除dummy_table后,再创建该表

drop table dummy_table;

create table dummy_table (
dummy_aln varchar2 (50) null,
dummy_integer number null,
dummy_smallint number null,
dummy_decimal number (15,2) null,
dummy_amount number (10,2) null,
dummy_float float null,
dummy_yorn number not null,
dummy_upper varchar2 (50) null,
dummy_lower varchar2 (50) null,
dummy_date date null,
dummy_time date null,
dummy_datetime date null,
dummy_duration float null,
dummy_crypto raw (30) null,
dummy_clob clob null,
dummy_tableid number not null,
dummy_blob blob null,
dummy_cryptox raw (10) null,
rowstamp varchar2 (40) not null
);


insert into dummy_table
( dummy_aln, dummy_integer, dummy_smallint, dummy_decimal, dummy_amount,
dummy_float, dummy_yorn, dummy_upper, dummy_lower, dummy_date,
dummy_time, dummy_datetime, dummy_duration, dummy_crypto, dummy_clob,
dummy_tableid, dummy_blob, dummy_cryptox, rowstamp)
values
(' ', null, null, null, null,
null, 1, null, null, null,
null, null, null, null, empty_clob(),
1, empty_blob(), null, maxseq.nextval);



create unique index dummy_table_ndx on dummy_table (dummy_tableid);
create unique index dummy_table_ndx1 on dummy_table (dummy_aln);


CREATE OR REPLACE TRIGGER DUMMY_TABLE_T BEFORE INSERT OR UPDATE ON DUMMY_TABLE FOR EACH ROW DECLARE NEXTVAL INTEGER;
BEGIN SELECT MAXSEQ.NEXTVAL INTO NEXTVAL FROM DUAL; :NEW.ROWSTAMP := NEXTVAL; END;
/



--3、恢复dummy_table中dummy_crypto列数据

update dummy_table t set t.dummy_crypto=( select dummy_crypto from dummy_table_temp );

commit;

drop table dummy_table_temp;

jryang

问题已经解决！谢谢大佬们！就是用的邓前辈的方法！不过不知道是怎么回事？要不在跟跟帖！

[ 本帖最后由 jryang 于 2007-12-8 16:39 编辑 ]