214: -- ----------------------------------------------------------------------------
215: -- Initialize variables.
216: -- ----------------------------------------------------------------------------
217: IF p_trace_mode = 'Y' THEN
218: dbms_session.set_sql_trace(TRUE);
219: ELSE
220: dbms_session.set_sql_trace(FALSE);
221: END IF;
222:
216: -- ----------------------------------------------------------------------------
217: IF p_trace_mode = 'Y' THEN
218: dbms_session.set_sql_trace(TRUE);
219: ELSE
220: dbms_session.set_sql_trace(FALSE);
221: END IF;
222:
223: IF (p_log_to_file <> 'Y') THEN
224: g_log_to_file := 'N';