My Oracle Support Banner

MDSDBService Show Errors When Statement Contains Single Quotes (Doc ID 1331556.1)

Last updated on JULY 27, 2022

Applies to:

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


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 





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.