oracle8.1.6 declare begin notification.delete(:notification_id); end; insert into notification_user_map (notification_id, user_id, sent_date) select :notification_id, :user_id, sysdate from dual where exists (select 1 from notifications where notification_id = :notification_id)