PL/SQL NOTIFICATION WRONGLY GATHER NLS_NUMERIC_CHARACTERS FROM CDB LEVEL INSTEAD OF PDB LEVEL
(Doc ID 2762526.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
When Root container and PDB has different Character set. Then AQ's PLSQL Notification module, while invoking user callbacks in a pdb inherits root containers character set and does not use PDB's character set.
When PLSQL Notification callback procedure uses character set used in root container instead of current PDB.
Example:
ROOT has NLS_NUMERIC_CHARACTERS = ., (dot-followed by-comma)
PDB has NLS_NUMERIC_CHARACTERS = ,. (comma-followed by-dot)
Changes
Bug 32035162 - PL/SQL NOTIFICATION WRONGLY GATHER NLS_NUMERIC_CHARACTERS FROM CDB LEVEL INSTEAD OF PDB LEVEL
Bug 32183756 - REGRESSION TRACKING BUG FILED FROM MERGEREQ
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 |