alter table test modify (col text) (from column type clob) needs cast?
hi there
if i try to change the type from clob to text or blob to byte i get the
error
listed below. how can i create and use this CAST i apparently need?
any help appreciated
regards
hoyte swager
> alter table bks modify (inf text);
9633: ALTER TABLE can not modify column (inf) type. Need a cast from thecurrent type
to the new type.
Error in line 1Near character position 32
> !finderr 9633
-9633 ALTER TABLE cannot modify column (column_name) type. Need a cast
from
the current type to the new type.
Conversions of column types require a cast. Use the CREATE CAST
statement to define a cast from the source to destination type.
> info columns for bks;
Column name Type Nulls
bks_id serial no
title varchar(127,1) yes
auth varchar(63,1) yes
inf_old varchar(255) yes
img_id integer yes
isbn varchar(128,0) yes
dtm datetime year to second yes
url varchar(63,0) yes
knd_id integer yes
inf clob yes