Dear All: The ViewName field in the database table sec.sec_function is inconsistent with the billing side, and many are missing: &businessid attempt to perform update sec.sec_function set V Iewname = ' http://billingtest.ailk.telenor.com:8095/acctmgnt/page/modules/setcredit/main.jsp?businesstype=${ BUSINESS_TYPE}&BUSINESSID=${BUSINESS_ID} ' where func_id=77000001; Hint Reason: Oracle thinks & is followed by variable modification method: A, with escape character: Sql> set escape \ sql> insert INTO table values (' \&aaaaa '); Sql> SELECT * from Mptlog_day t where URL like '%\&t=% '; Then & before adding \ such as \& B, close this function SET DEFINE off; Select Turn off this feature on update. SET DEFINE OFF; Sql> Show define
Define OFF
Finally execute SQL. Other special characters are%,_ and handled the same way.
When Oracle updates a table, the field contains the handling of special characters.