Im newbee in oracle and I try to add new column to existing type
create or replace type employee FORCE as object
( id VARCHAR2(8), code NUMBER(11), date NUMBER(8) ) /
earlier it was
create or replace type employee FORCE as object
( id VARCHAR2(8), code NUMBER(11) ) /
Error report: ORA-22866: cannot replace a type with table dependents
22866. 00000 - "default character set is of varying width" *Cause: A
character LOB was defined but the default character set is not fixed
width. *Action: Ensure that the character set is of fixed width before
defining character LOBs.
No comments:
Post a Comment