My Oracle Support Banner

PL/SQL NOTIFICATION WRONGLY GATHER NLS_NUMERIC_CHARACTERS FROM CDB LEVEL INSTEAD OF PDB LEVEL (Doc ID 2762526.1)

Last updated on MARCH 08, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and later
Information 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


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