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

Last updated on MARCH 18, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms