Hi

You acn have a work around..

create or replace trigger DEL_BINARY_CONTENT after delete on ATTRIBUTE_VALUE for each row
declare
child_exists exception;
pragma exception_init( child_exists, -2292 );
begin
delete from TABLE1 where oid = xxxx;
exception
when child_exists then
insert into test
values('Cannot delete BINARY_CONTENT as child exists')
WHEN others THEN
null;
end;

then you can query the test table and capture all your exacptions

regards
Hrishy