Skip to Main Content

Database Software

Modify VARCHAR2 column to CLOB one

yasuo.hondaApr 16 2018 — edited Apr 16 2018

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 - 64bit Production

I did not have a chance to try 18c yet.

Refer the original issue at Oracle enhanced adapter

Post Details
Added on Apr 16 2018