SEO

#1 (**permalink**) 02-26-2008, 07:40 AM

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=

ldRow.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.

#2 (**permalink**) 02-26-2008, 07:40 AM

tbl2 is a view?

#3 (**permalink**) 02-26-2008, 07:40 AM

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=

ldRow.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@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

#4 (**permalink**) 02-26-2008, 07:40 AM

cleveridea wrote:
> tbl2 is a view?
>

No. It's a table.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

ora-1410 on a delete trigger