Trace-Wizard
Trace-Wizard copied to clipboard
SQL Statement parsing does not handle newlines
Example:
PSAPPSRV.5922 (776) 1-1269 10.31.21 0.104118 Cur#2.5922.HR91SYS RC=0 Dur=0.096857 COM Stmt=select * from ( select rownum rnum, a.* from (SELECT 'T', MGR.EMPLID "MGR_EMPLID", N_MGR.NAME "MGR_NAME", MGR.SUPERVISOR_ID, EMP.EMPLID, EMP.EMPL_RCD, N_EMP.FIRST_NAME, N_EMP.LAST_NAME, N_EMP.NAME,
TraceWizard only shows "select *" on this. We should continue looking at subsequent lines untill we find one that matches the Context Marker regex. All lines in between should be counted as part of the SQL statement.