why " Alter table emp drop column news_no" doesn't work in Oracle 7.3.* ?

Hi ,

using Oracle 7.3.x now ( switch fast )
I did " Alter table emp add ( news_no, number(15,2));" ok . but " Alter table emp drop column news_no" doesn't work .

try many times , result is same .
Also , when I try OCI/C , it gives :
 Connected to ORACLE as scott
-- ORACLE error when processing OCI function OEXEC, OEXN ORA-00905: missing keyword
 Exiting with FAILURE status 1
when I try OO4O , it gives :
ErrorNumber()= 8196

" Alter table emp drop column news_no" statement problem ? or others .

thanks Received on Sun Dec 09 2001 - 08:19:27 CST