My Oracle Support Banner

How to use the 'OPA_TRACE' database package to debug PL/SQL code. (Doc ID 2118061.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Clinical - Version 4.6.0 and later
Oracle Clinical Remote Data Capture Option - Version 4.6.0 and later
Oracle Thesaurus Management System - Version 4.6.0 and later
Information in this document applies to any platform.

Goal

The purpose of this note is to provide an example of how to use the OPA_TRACE database package to debug PL/SQL code issues. The OPA_TRACE calls can be embedded in existing PL/SQL code (e.g. Validation/Derivation procedures, custom Flex Field functions in the RDC_CLIENT package) and the debug output gets written to the OPA_DEBUG table.

Note: Once the issue is resolved then the OPA_TRACE code which was added should be removed or commented out to avoid unnecessary output being written to the debug table.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.