SQL & PL/SQL

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!

ORA-01732 when trying to update data straight into a table

471143Nov 23 2005 — edited Nov 23 2005

Hi all

I have a table in a database (think it's oracle 9.something) called DPIP.DEDUCTIONS. I am trying to run a statement like this in some VB code

UPDATE DPIT.DEDUCTIONS SET END_DATE = '01-DEC-05' WHERE EMPLOYEE# = '09039351' AND PAYCODE = 'EVBIN';

and I keep getting the error message ORA-01732 Data manipluation on this table not legal on this view.

I would have thought this message would have been reserved only for views (and this to the best of my knowledge is a table!). If I go into the front end I can update the table no problems, just not using this update statement? Anybody have any ideas as to why I might be getting this error message

regards

cameron

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2005

Added on Nov 23 2005

2 comments

524 views