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 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
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 |