My Oracle Support Banner

Sync/Apply Character Column (Doc ID 1161424.1)

Last updated on FEBRUARY 06, 2019

Applies to:

Siebel Tools - Version SIA[21215] 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:

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:
(Customer also checked NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252 with same result)


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

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