Hi, I am maintaining Oracle enhanced adapter for Active Record.
I'd like Oracle database to support modify VARCHAR2 column to CLOB.
Right now, it gets ORA-22858 error.
SQL> create table foo (comments varchar2(255));
Table created.
SQL> alter table foo modify comments clob;
alter table foo modify comments clob
*
ERROR at line 1:
ORA-22858: invalid alteration of datatype
I'm using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
I did not have a chance to try 18c yet.
Refer the original issue at Oracle enhanced adapter
https://github.com/rsim/oracle-enhanced/issues/1675