MDSDBService Show Errors When Statement Contains Single Quotes

(Doc ID 1331556.1)

Last updated on DECEMBER 07, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.9.0.2 to 1.12.0.3 [Release 1.9 to 1.12]
Oracle Network Management for Utilities - DMS - Version 1.10.0.1 to 1.12.0.3 [Release 1.10 to 1.12]
Information in this document applies to any platform.

Symptoms

When updating orders from MDS, the MDSDBService log shows errors

-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'update picklist_info_abn_cnd set notes_text1 = 
'Cancelled in MS by AA at 07:52 06/01/2011. CT - broken 30'5 pole carries 1/0 qa,
 main line bell, catv, and traffic lights. set in concrete in front of old a's
 restaurant. set in concrete. tied up safe. pls send abnormal to region to replace
 pole.', abn_fun1='N' where abn_ref_id= 1234567'
ORA-00933: SQL command not properly ended 

 

Changes

 

Cause

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