RPT_TRACE_DETAILS

This table stores the file, line, and function that need to perform SQL level trace during full ETL or incremental ETL. Enable trace log for the SQLs you noted down by adding the file name, line number, and function name of the rows to the RPT_TRACE_DETAILS table.

If you add file name and set line number to -1, the SQL trace log stays open for the entire package body file.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
FILE_NAME	NOT NULL	NUMBER	PLSQL package body file name
LINE_NO	NULLABLE	NUMBER	Line number in package body source file
FUNC_NAME	NULLABLE	NUMBER	Function name of the package

Indexes

Index Name	Index Type	Sequence	Column Name
RPT_TRACE_DETAILS_N1	NONUNIQUE	1	FILE_NAME
RPT_TRACE_DETAILS_N2	NONUNIQUE	1	LINE_NO
RPT_TRACE_DETAILS_N3	NONUNIQUE	1	FUNC_NAME

Sequences

This table does not use any sequences.