Inserts of Metadata with Apostrophes Into IBM UDB/DB2 Database Throws SQL Error: "SQLCODE: -104, SQLSTATE: 42601"
Last updated on FEBRUARY 06, 2018
Applies to:Oracle WebCenter Content - Version 7.5.0 to 10.1.3.6.0 [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:
(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';
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms