ora-1410 on a delete trigger

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Mon, 27 Aug 2007 17:16:14 GMT
Message-ID: <yFDAi.528$hV.6@trnddc02>

Any idea why an application would be getting ora-1410 (invalid rowid) on the trigger below?

CREATE OR REPLACE TRIGGER t_tbl1
  after delete on tbl1
  referencing old AS oldRow
  for each row
begin

  delete from	tbl2
         where	tbl2.media_id=:oldRow.media_id
	 and	tbl2.PARTNER_ID is not null;

end t_tbl1;

There are no triggers on tbl2. The application makes no use of "where current of" cursors, nor does it ever directly reference a rowid. Received on Mon Aug 27 2007 - 12:16:14 CDT