ORA-3113 During delete from with subquery

Anyone else experience this?
OS: Solaris 8
DB: 10g (10.1.0.3)
My delete returns an ORA-3113 when I execute this on my 10g databases,
but it works fine on my 8.1.7 databases.

Here is my DML:

DELETE FROM v_trn_event_attendees=20
WHERE pers_id =3D 86409
AND class_id IN (SELECT a.class_id=20
                        FROM trn_events e, trn_event_attendees a =20
                        WHERE e.class_id =3D a.class_id=20
                        AND pers_id =3D 86409
                        AND element_id =3D 1015891
                        AND date_conducted =3D (select max(date_conducted)=
=20
                                                            from
trn_events e, trn_event_attendees a
                                                            where
e.class_id =3D a.class_id
                                                            and pers_id =3D=
86409
                                                            and
element_id =3D 1015891
                                                            and
date_conducted <=3D '25-APR-2005'))
/


Thanks in advance..
Scott
--
http://www.freelists.org/webpage/oracle-l

Other related posts: