SAP Knowledge Base Article - Preview

2066935 - Error ORA-22859 after changing column data type from BLOB to VARCHAR2 – SAP PD 16.5


  • Data type of an Oracle table column is changed from BLOB to VARCHAR2.
  • PowerDesigner generates an ALTER TABLE table_name MODIFY column_name statement.
  • Executing the script generated by PowerDesigner leads to error "ORA-22859: invalid modification of columns".
  • The alter.sql file should drop then create the table again.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.



  • SAP PowerDesigner (PD) 16.5
  • SAP PowerDesigner (PD) 16.5 SP03
  • SAP PowerDesigner (PD) 16.5 SP04


SAP PowerDesigner 16.5 ; Sybase PowerAMC 16.5


CR770661, 770661 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.