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.