Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: