The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'errors exist'
from wf_item_activity_statuses
where activity_status = 'ERROR'
and begin_date >= nvl(lastrun,begin_date);
select ias.item_type,
ias.item_key,
ac.name Activity,
ias.activity_result_code Result,
-- ias.error_name ERROR_NAME,
ias.error_message ERROR_MESSAGE,
ias.error_stack ERROR_STACK
from wf_item_activity_statuses ias,
wf_process_activities pa,
wf_activities ac,
wf_activities ap,
wf_items i
where ias.activity_status = 'ERROR'
and ias.process_activity = pa.instance_id
and pa.activity_name = ac.name
and pa.activity_item_type = ac.item_type
and pa.process_name = ap.name
and pa.process_item_type = ap.item_type
and pa.process_version = ap.version
and i.item_type = ias.item_type
and i.item_key = ias.item_key
and i.begin_date >= ac.begin_date
and i.begin_date < nvl(ac.end_date, i.begin_date+1)
order by ias.begin_date, ias.execution_time;