View Single Post
Old 01-30-2013, 08:58 PM   PM User | #5
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,555
Thanks: 62
Thanked 4,054 Times in 4,023 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
Oracle does allow you to DELETE from views, but then it puts restrictions on that (which I think you'd need to be an Oracle guru to understand...some are really weird!).

Is it possible that is what is happening here? That you think you are deleting from a table but it's really from a VIEW of a table?
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is online now   Reply With Quote