The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sid
INTO session
FROM v$session
WHERE audsid = userenv('SESSIONID');
SELECT value
INTO udump
FROM v$parameter
WHERE name = 'user_dump_dest';
select application_short_name , concurrent_program_name,
round((sysdate-fcr.actual_start_date)*24*60*60,2)
, fcr.phase_code , fcr.status_code , actual_start_date,
actual_completion_date,
lower(instance_name) || '_ora_' || fcr.oracle_process_id
|| '.trc' , instance_name, parent_request_id,
version
into module_id, flow_id, vduration, phase_code , status_code,
sdate, cdate, tracefile , vdbname, parentreqid, vversion
from fnd_concurrent_requests fcr, fnd_application fa,
fnd_concurrent_programs fcp, v$instance
where fcr.request_id = p_req_id
and fcr.program_application_id = fa.application_id
and fcr.concurrent_program_id = fcp.concurrent_program_id
and fcr.program_application_id = fcp.application_id;
SELECT sid
INTO session
FROM v$session
WHERE audsid = userenv('SESSIONID');
SELECT value
INTO udump
FROM v$parameter
WHERE name = 'user_dump_dest';
select application_short_name , concurrent_program_name,
lower(instance_name) || '_ora_' || fcr.oracle_process_id
|| '_' || p_req_id || '.trc' , instance_name, parent_request_id,
version
into module_id, flow_id, tracefile , vdbname, parentreqid, vversion
from fnd_concurrent_requests fcr, fnd_application fa,
fnd_concurrent_programs fcp, v$instance
where fcr.request_id = p_req_id
and fcr.program_application_id = fa.application_id
and fcr.concurrent_program_id = fcp.concurrent_program_id
and fcr.program_application_id = fcp.application_id;
SELECT sid
INTO session
FROM v$session
WHERE audsid = userenv('SESSIONID');
SELECT value
INTO udump
FROM v$parameter
WHERE name = 'user_dump_dest';
select application_short_name , concurrent_program_name,
round((sysdate-fcr.actual_start_date)*24*60*60,2),
lower(instance_name) || '_ora_' || fcr.oracle_process_id
|| '_' || p_req_id || '.trc' , instance_name, parent_request_id,
version
into module_id,flow_id,vduration,tracefile,vdbname,parentreqid,vversion
from fnd_concurrent_requests fcr, fnd_application fa,
fnd_concurrent_programs fcp, v$instance
where fcr.request_id = p_req_id
and fcr.program_application_id = fa.application_id
and fcr.concurrent_program_id = fcp.concurrent_program_id;
select spid into vspid
from v$process p,v$session s
where p.addr = s.paddr
and s.audsid = userenv('SESSIONID');
raise_application_error(-20100,'Error select SPID ...');
select instance_name
into vinstance
from v$instance i;
raise_application_error(-20100,'Error select Instance ...');
vsql := 'insert into rt_icx_data@rtperf
( icxid , spid , instance , techstack , creation_date, request_id) select :b1 , :b2, upper(:b3), :b4, sysdate, :b5 from dual
where not exists ( select ''x'' from rt_icx_data@rtperf
where icxid = :b6 and spid = :b7 and instance = upper(:b8)
and techstack = upper(:b9)) ';