我正在连接一些文本,我得到这个奇怪的错误,我找不到任何关于
UPDATE Table1 a
SET a.AllTexts = a.Text
|| a.Title
||
(SELECT XMLAGG(XMLELEMENT(E,"Text",',').EXTRACT('//text()')).GetClobVal()
FROM Table2 b
WHERE b.El_Id = a.Id
)
所有文本CLOB
,所有其他列都VARCHAR2
我得到
Error report -
SQL Error: ORA-64451: Conversion of special character to escaped character failed.
64451. 00000 - "Conversion of special character to escaped character failed."
*Document: NO
*Cause: An attempt to convert a special character to an escaped character failed.
*Action: Remove the special character that cannot be escaped.
编辑:错误是由一些奇怪的符号引起的。问题是没有办法提前知道哪些交易品种会阻止执行
我得到了这个错误代码,这对我有用
REGEXP_REPLACE(COLUMN, '[^[:print:]]', '')