ORA-00904: "WMSYS"."WM_CONCAT": invalid identifier (文档 ID 2215183.1)
来源:互联网 发布:js修改style属性值 编辑:程序博客网 时间:2024/05/29 16:30
APPLIES TO:
Oracle Transportation Management Cloud Service - Version 6.4.1 and laterOracle Transportation Management - Version 6.4.1 and later
Oracle Global Trade Management Cloud Service - Version 6.4.1 and later
Oracle Global Trade Management - Version 6.4.1 and later
Information in this document applies to any platform.
SYMPTOMS
You have an agent which is failing on a Direct SQL in call with error
CAUSE
The database function WM_CONCAT is being used.
WM_CONCAT is undocumented and unsupported by Oracle meaning it should not be used in production systems.
This function has been removed from Oracle 12c.
Since version 6.4.1 includes a database update to 12c this function can no longer be used.
SOLUTION
The Oracle PL/SQL WM_CONCAT function is used to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. In effect, it cross-tabulates a comma delimited list.
WM_CONCAT is gone in 12c.
Use the LISTAGG function instead, which can produce the same output as WM_CONCAT is both documented and supported by Oracle.
Basic Syntax:
Def LISTAGG http://psoug.org/definition/LISTAGG.htm
http://dba.stackexchange.com/questions/696/eliminate-duplicates-in-listagg-oracle
- ORA-00904: "WMSYS"."WM_CONCAT": invalid identifier (文档 ID 2215183.1)
- ORA:WMSYS.WM_CONCAT函数
- ORA-00904: : invalid identifier
- ORA-00904::invalid identifier
- ORA-00904:invalid identifier
- ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的解决办法
- ORA-00904: "POLTYP": invalid identifier
- ORA-00904: "POLTYP": invalid identifier
- ORA-00904: “MAXSIZE”: invalid identifier
- ORA-00904: "MAXSIZE": invalid identifier
- ORA-00904: invalid identifier解决方法
- ORA-00904:invalid identifier错误的解决办法
- ORA-00904: "DROP_SEGMENTS": invalid identifier 解决方法
- ORA-00904: "POLTYP": invalid identifier 错误
- 解决ORA-00904: invalid identifier标识符无效
- ORA-00904: invalid identifier标识符无效
- Oracle ORA-00904:invalid identifier 标识符无效
- wmsys.wm_concat
- Python yield 生成器
- mongodb初体验
- Matlab安装使用libsvm
- logstash @timestamp 内容替换
- NSA黑客工具泄露 网络世界的灾难级危机如何应对?[NSA黑客工具名单]
- ORA-00904: "WMSYS"."WM_CONCAT": invalid identifier (文档 ID 2215183.1)
- HDU 3480 DP斜率优化 解题报告
- hdu3480 四边形不等式DP 解题报告
- ShadowBroker攻击框架FuzzBunch实战之EternalBlue
- 算法分析与设计课程(12):【leetcode】 Count Complete Tree Nodes
- 闪屏页的初级实现
- nuttx操作系统的移植以及下载
- 精确率与召回率,RoC曲线与PR曲线
- hexo(二)移植