Incorrect FORCE MATCHING SIGNATURE for SQL with a Mix of LITERAL AND BIND Variables
(Doc ID 2925716.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 21.3 [Release 12.1 to 21.0]Information in this document applies to any platform.
Symptoms
FORCE_MATCHING_SIGNATURE Keeps Changing for a Query with LITERALS and BIND Variables.
The SQL TEXT for all the Above SQLID's has both Application Defined BIND Variable and LITERAL Mix. The SQL Structure is all same only with the change in LITERAL Values
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 |