The following lines contain the word 'select', 'insert', 'update' or 'delete':
select num_rows
into l_num_rows
from all_tables
where owner=l_object_owner
and table_name=l_object_log;
bis_collection_utilities.put_line('Calling BIS_COLL_RS_HISTORY.insert_program_object_data ');
BIS_COLL_RS_HISTORY.insert_program_object_data
(x_request_id => l_request_id,
x_stage_req_id =>null,
x_object_name =>objectname,
x_object_type =>objecttype,
x_refresh_type =>'ANALYZED',
x_set_request_id =>l_root_request_id);
BIS_COLL_RS_HISTORY.insert_program_object_data
(x_request_id => l_request_id,
x_stage_req_id =>null,
x_object_name =>l_object_log,
x_object_type =>'MV_LOG',
x_refresh_type =>'ANALYZED',
x_set_request_id =>l_root_request_id);
bis_collection_utilities.put_line('Called BIS_COLL_RS_HISTORY.insert_program_object_data');
bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);