My Oracle Support Banner

Using “executeSQLQryForSingleRecord” Function Under OUTSPCORELIB. OUTA Using Default Database (Doc ID 2684017.1)

Last updated on JULY 12, 2020

Applies to:

Oracle Utilities Testing Accelerator - Version 6.0.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On : OUTA 6.0.0.2.0 version, Core UTA Framework

Using “executeSQLQryForSingleRecord” function under oUTSPCORELIB. OUTA Using default Database.

ACTUAL BEHAVIOR
---------------
When using “executeSQLQryForSingleRecord” function under oUTSPCORELIB where OUTA is using the default DB connection instead of using DB connection related to the component where the function is being called.

EXPECTED BEHAVIOR
-----------------------
MDM DB to be used instead of default database.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Configure Default DB & MDM DB.
2. Execute.
3. According to the logs, the connection being used is the default instead of the MDM.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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