Generated SQL from database diagram changes isn't valid
447726Feb 21 2006 — edited Feb 21 2006Hi,
When changing a column name and it's type (say varchar to number) in a database diagram, JDeveloper generates ALTER code like
ALTER TABLE tablename
RENAME COLUMN "col1" TO "col2" MODIFY ("col2" NUMBER(8))
;
Running this code gives
ORA-23290: This operation may not be combined with any other operation
The generated code should be:
ALTER TABLE tablename
RENAME COLUMN "col1" TO "col2"
;
ALTER TABLE tablename
MODIFY ("col2" NUMBER(8))
;