Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update failure in datatab

481013Mar 3 2006 — edited Mar 3 2006
open tablea, alter table in worksheet - add column. refresh data on tab. column appears (ok). try changing data in that column, updates fail on commit. Update statement follows:

UPDATE "USER"."CO_LINK_DUPLICATE" SET null = "1" WHERE ROWID = 'AAA0dsAAqAAAQuKACi'

failure message
Row 1: ORA-01747: invalid user.table.column, table.column, or column specification

I don't think that the commit button recgonizes the new column, hence the set null = 1 part.

build 1422, w2k, 9206

Message was edited by:
ctryon2414
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2006
Added on Mar 3 2006
#sql-developer
3 comments
314 views