Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

Table: CAM_RUNTIME_ERR_LOGS

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17383  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Record errors occurred during runtime. Error records inserted with P_LOG_RUNTIME_ERROR procedure.

Description

Record errors occurred during runtime. Error records inserted with P_LOG_RUNTIME_ERROR procedure.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CAM_RUNTIME_ERR_LOG_SEQ
NUMBER 		Primary key for APP_RUNTIME_ERR_LOG table
ERROR_LOCATION
VARCHAR2 		Detailed location where error occurred. Package name, function name, procedure name..
PARAMETERS
VARCHAR2 		Arguments used.
SQLCODE
VARCHAR2 		Oracle error code
SQLERRM
VARCHAR2 		Oracle Error message
USER_ID
VARCHAR2 		User executes the function/procedure/package. Application User ID(APP_ID) if executed from an application or DB user id(USER)
APEX_APPLICATION_ID
VARCHAR2 		Apex application id (number) where the error occurred from. if applicable
APP_SEQ
NUMBER 		Primary key sequence in CAM_MODULES
USER_SEQ
NUMBER 		Primary key for CAM_X_USER_TYPE
ERROR_OCCURRED_TIMESTAMP
TIMESTAMP(6) 		date and time when the error occurred.
ERR_LOG_NOTE
VARCHAR2 		Note on error. Usually procedure or system generated.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Table: CAM_RUNTIME_ERR_LOGS
Short Name: CAM_RUNTIME_ERR_LOGS
Status: Completed
Abstract:

Record errors occurred during runtime. Error records inserted with P_LOG_RUNTIME_ERROR procedure.
Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CUST_AUTH
Description:

Record errors occurred during runtime. Error records inserted with P_LOG_RUNTIME_ERROR procedure.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key CAM_RUNTIME_ERR_LOG_SEQ NUMBER Primary key for APP_RUNTIME_ERR_LOG table
100
 ERROR_LOCATION VARCHAR2 Detailed location where error occurred. Package name, function name, procedure name..
100
 PARAMETERS VARCHAR2 Arguments used.
100
 SQLCODE VARCHAR2 Oracle error code
100
 SQLERRM VARCHAR2 Oracle Error message
100
 USER_ID VARCHAR2 User executes the function/procedure/package. Application User ID(APP_ID) if executed from an application or DB user id(USER)
100
 APEX_APPLICATION_ID VARCHAR2 Apex application id (number) where the error occurred from. if applicable
100
 APP_SEQ NUMBER Primary key sequence in CAM_MODULES
100
 USER_SEQ NUMBER Primary key for CAM_X_USER_TYPE
100
 ERROR_OCCURRED_TIMESTAMP TIMESTAMP(6) date and time when the error occurred.
100
 ERR_LOG_NOTE VARCHAR2 Note on error. Usually procedure or system generated.

Attribute Details

CAM_RUNTIME_ERR_LOG_SEQ

CC ID: 84284
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary key for APP_RUNTIME_ERR_LOG table
General Data Type: NUMBER

ERROR_LOCATION

CC ID: 84285
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Detailed location where error occurred. Package name, function name, procedure name..
General Data Type: VARCHAR2

PARAMETERS

CC ID: 84286
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Arguments used.
General Data Type: VARCHAR2

SQLCODE

CC ID: 84287
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Oracle error code
General Data Type: VARCHAR2

SQLERRM

CC ID: 84288
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Oracle Error message
General Data Type: VARCHAR2

USER_ID

CC ID: 84289
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

User executes the function/procedure/package. Application User ID(APP_ID) if executed from an application or DB user id(USER)
General Data Type: VARCHAR2

APEX_APPLICATION_ID

CC ID: 84290
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Apex application id (number) where the error occurred from. if applicable
General Data Type: VARCHAR2

APP_SEQ

CC ID: 84293
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Primary key sequence in CAM_MODULES
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_APPS

USER_SEQ

CC ID: 84294
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Primary key for CAM_X_USER_TYPE
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_USERS

ERROR_OCCURRED_TIMESTAMP

CC ID: 84291
Seq. Order: 10
Data Storage Type: TIMESTAMP(6)
Max Length: 11
Required: Yes
Primary Key: No
Scale: 6
Status: Active
Description:

date and time when the error occurred.
General Data Type: TIMESTAMP(6)

ERR_LOG_NOTE

CC ID: 84292
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Note on error. Usually procedure or system generated.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17383
GUID: gov.noaa.nmfs.inport:17383
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18