alter VARCHAR column to TEXT under Oracle

Changing a VARCHAR column to CLOB (TEXT) raises the following exception under Oracle: sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-22858: invalid alteration of datatype [SQL: 'ALTER TABLE tab MODIFY col CLOB'] While this is an Oracle fault, it would be nice if the abstraction

Re: alter VARCHAR column to TEXT under Oracle

On 11/08/2015 05:42 AM, Ofir Herzas wrote: > Changing a VARCHAR column to CLOB (TEXT) raises the following exception > under Oracle: > > | > sqlalchemy.exc.DatabaseError:(cx_Oracle.DatabaseError)ORA-22858:invalid > alteration of datatype > [SQL:'ALTER TABLE tab MODIFY col CLOB'] > > | > >

RE: alter VARCHAR column to TEXT under Oracle

Thanks Mike, I was hoping for a under-the-hood solution rather than a recipe since it's a must for using Oracle. Nevertheless, if I get around it, I will provide the recipe (better to have something...) In the meanwhile, I opted to stay with VARCHAR ... Thanks again, Ofir -Original