For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
SQL> create table t1 2 (col1 long); Table created. SQL> SQL> create table t2 2 as 3 select col1 from t1; select col1 from t1 * ERROR at line 3: ORA-00997: illegal use of LONG datatype SQL> create table t2 2 as 3 select to_lob(col1) col1 from t1; Table created. SQL> drop table t2; Table dropped. SQL> create table t2 2 (col1 varchar2(4000)); Table created. SQL> insert into t2 2 select to_lob(col1) from t1; 0 rows created. SQL> drop table t2; Table dropped. SQL> drop table t1; Table dropped. SQL>
SQL> select to_lob(col1) from t1; select to_lob(col1) from t1 * ERROR at line 1: ORA-00932: inconsistent datatypes: expected - got LONG