Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle error?

Status
Not open for further replies.

eflavin

Technical User
Joined
Jun 9, 2001
Messages
4
Location
IE
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top