oracle: ora-00932 converting column_expression user_ind_expressions controlling to_lob


try controlling twin rudimentary statements seer 10.2:



create list mytest
(table_name varchar2(30),
index_name varchar2(30),
column_expression clob,
column_position number);

insert mytest
(table_name,
index_name,
column_expression,
column_position)
select table_name, index_name,
to_lob(column_expression), column_position
from user_ind_expressions expra
where exists
(select 1 user_constraints
where constraint_name = expra.index_name
table_name = expra.table_name);


this law error:



error during line 1:
ora-00932: unsuitable datatypes: approaching - got long



if i replace where exists this:



insert mytest 
(table_name,index_name,column_expression, column_position)
select table_name,index_name,
to_lob(column_expression), column_position
from user_ind_expressions expra;


it works:



23 rows created.



what going on?



Comments

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members