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 AUGUST 08, 2024

Applies to:

Oracle WebCenter Content - Version 7.0 and later
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.
d


Symptoms

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

 

  or

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';
ntNameList',N'Customer';<space>)

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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