SOA 11g: Characters are Garbled when Dequeueing the Messages from AQ using Oracle AQ Adapter in Oracle BPEL (Doc ID 1563146.1)

Last updated on MARCH 27, 2020

Applies to:

Symptoms

When using the AQ Adapter in BPEL, with customer data that has German characters like Jörg. When the message is received it is properly displayed in Oracle EM console and it is correctly enqueued into Oracle AQ tables but when the message is dequeued by the target process, the characters are garbled for "ö".

When the same message is dequeued by Oracle database API, the character is not garbled

 
Below is the actual example.

Data when received into SOA

  100022
  
  H
  <USER_NAME> xxxxx
  c/o Jörg XXXXX
  XXXXx
  

 
Data after dequeued from the Queue using Oracle AQ adapter

  100022
  
  H
  <USER_NAME> xxxx
  c/o Jörg xxxxxx
  xxxxx
  
 

Changes

Cause

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