My Oracle Support Banner

Inserts of Metadata with Apostrophes Into IBM UDB/DB2 Database Throws SQL Error: "SQLCODE: -104, SQLSTATE: 42601" (Doc ID 446945.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle WebCenter Content - Version 7.5.0 to [Release Stellent to 10gR3]
Information in this document applies to any platform.
This issue can occur when attaching to an IBM DB2/UDB database with Content Server via JDBC.


Inserts of metadata with apostrophes, including inserts of Options List data, into an IBM UDB/DB2 Database during check-in or Configuration Manager use, fail with DB2 SQL Error:


SQL0104N An unexpected token ....... SQLSTATE=42601



Error Updating options list. Unable to execute service UPDATE_OPTIONS_LIST and
function updateOptionsList.
(System Error: Unable to execute query 'Ioption(INSERT INTO OptionsList (dKey,
dOption, dOrder) values (N'ClientNameList',N'Customer''s Name',3))'.
DB2 SQL error: SQLCODE: -104, SQLSTATE:42601, SQLERRMC: 's Name';


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.