Sync/Apply Character Column (Doc ID 1161424.1)

Last updated on FEBRUARY 06, 2019

Applies to:

Goal

Customer experienced problem with newly created 'character' column.
They created column with following definition:

Column was created in database after Apply (or Sync) with value N for existing records in table. Later in application they got error: (oracon.cpp (3246)) SBL-DBC-00105: An error has occurred executing a Sql statement.

Customer found out that value N stored in DB has 4bytes. Using dump in SQL statement - "Typ=1 Len=4: 78,0,0,0".

Customer has update column with 'N' value through SQL developer and application start working correctly. Value stored in DB is "Typ=1 Len=1: 78".

Customer has perform additional testing (also on vanilla environment) with following result:
If they set value or create new record through Web Client, Developer Client or PLSQL Developer value in DB is 'N' - "Typ=1 Len=1: 78".
If they apply changes from Siebel Tools or run Sync utility,value in DB is 'N' - "Typ=1 Len=4: 78,0,0,0".

Customer wanted an explanation regarding to above behavior?

Customer settings:
DB: AL32UTF8
NLS_LANG: SLOVAK_SLOVAK.AL32UTF8
(Customer also checked NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252 with same result)

Solution

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