Re: ora-1410 on a delete trigger

Chuck wrote:
> 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.

Try changing this to a BEFORE DELETE trigger.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com