gpt4 book ai didi

oracle - ORA-64451 : Conversion of special character to escaped character failed

转载 作者:行者123 更新时间:2023-12-02 07:13:59 38 4
gpt4 key购买 nike

我正在连接一些文本,但出现了一个奇怪的错误,我找不到任何相关信息

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
)

AllTexts 为 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:]]', '') 

关于oracle - ORA-64451 : Conversion of special character to escaped character failed,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/41749765/

38 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com