特殊字符处理 UTL_RAW.CAST_TO_RAW dblink乱码也可以

原创于 2023-12-11 01:10:34 发布 · 593 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#java #数据库 #开发语言

收录于

文章讲述了在创建数据库服务时意外包含无法正确显示的特殊字符，通过将服务名转换为RAW类型并使用UTL_RAW.CAST_TO_VARCHAR2函数删除含有该字符的服务，提供了解决方案。

Accidentally created a service name via DBMS_SERVICE.CREATE_SERVICE which contains a special character that's not displaying correctly.

SOLUTION

Cast the whole service name in raw using UTL_RAW package and delete statement while issuing the raw string as input in a UTL_RAW.CAST_TO_VARCHAR2 function.

This should delete it:

SELECT UTL_RAW.CAST_TO_RAW(NAME) FROM ALL_SERVICES WHERE NAME LIKE '<READABLE_SERVICE_NAME>%';

EXEC DBMS_SERVICE.DELETE_SERVICE(UTL_RAW.CAST_TO_VARCHAR2('<RESULT FROM ABOVE>'));