resumble_handle_trigger.sql

create or replace trigger resumble_handle
after suspend
on database
declare
error_no number;
session_no number;
begin
select error_number into error_no from dba_resumable;
select session_id into session_no from dba_resumable;
handle_suspend(error_no,session_no);
end;
/