KNTA_DEBUG_MESSAGES

This table is used by PL/SQL packages for storing log messages that might be useful during debugging.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

DEBUG_MESSAGE_ID

NOT NULL

NUMBER

System-generated identifier

DEBUG_SESSION_ID

NOT NULL

NUMBER

This identifies the database transaction within which this debug message was logged.

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

DEBUG_LEVEL

NOT NULL

NUMBER

This specifies the level of this message. This column can be used for sorting and/or formatting of messages.

PACKAGE_NAME

NULLABLE

VARCHAR2(30)

This identifies the package which generated this debug message.

BLOCK_NAME

NULLABLE

VARCHAR2(30)

This identifies the procedure or function which generated this debug message.

DEBUG_COMMENT

NULLABLE

VARCHAR2(2000)

This is the text of the debug message.

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_DEBUG_MESSAGES_N1

NONUNIQUE

1

DEBUG_SESSION_ID

KNTA_DEBUG_MESSAGES_N1

NONUNIQUE

2

DEBUG_MESSAGE_ID

KNTA_DEBUG_MESSAGES_N2

NONUNIQUE

1

CREATION_DATE

Sequences

Sequence Name

Sequence Type

KNTA_DEBUG_MESSAGES_S

DEBUG_MESSAGE_ID

KNTA_DEBUG_SESSIONS_S

DEBUG_SESSION_ID