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.