Sync/Apply Character Column
(Doc ID 1161424.1)
Last updated on FEBRUARY 06, 2019
Applies to:
Siebel Tools - Version 8.1.1.2 SIA[21215] and laterInformation 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:
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
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
Goal |
Solution |
References |