Sync/Apply Character Column
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 22.214.171.124 SIA and later
Information in this document applies to any platform.
Checked for relevance on 10-Sep-2013.
Customer experienced problem with newly created 'character' column.
They created column with following definition:
Physical Type: Character
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 also checked NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252 with same result)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms