Oracle error?

[eflavin]

Hi there

I wonder could any give me a reason why running in the following SQL would give the error belowto a table would give this error.

alter table SERV_INS
add(ZSI_FREE_FIVE VARCHAR2(5));

update SERV_INS
set ZSI_FREE_FIVE =' ';

alter table SERV_INS
modify(ZSI_FREE_FIVE VARCHAR2(5) NOT NULL);




set ZSI_XTRA_FIVE =' ',
*
ERROR at line 3:
ORA-01747: invalid user.table.column, table.column, or column specification

 

[Tim1]

Hiya,

I would suggest that you post this in the Oracle forum.

From what I can see, with my limited knowledge of Oracle, that all looks OK.

Tim.