Sync/Apply Character Column

(Doc ID 1161424.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.2 SIA[21215] and later
Information in this document applies to any platform.
Checked for relevance on 10-Sep-2013.

Goal


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

Default: N
Physical Type: Character
Length: 1
Nullable: False
Required: True



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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms