前段时间support印度客户升级系统(从AIX到Linux6.3上),其中碰到一个ORA-2437: Warning of a NULL column in an aggregate function这个错误,Oracle帮助解释:
ORA-24347 Warning of a NULL column in an aggregate function
Cause: A null column was processed by an aggregate function.
Action: An OCI_SUCCESS_WITH_INFO is returned
所以解决办法就是对于NULL column的field进行处理一下,一般用NVL。
可以参考下面的文章:http://knowledgebase.progress.com/articles/Article/000038909
SQL QUERY USING AGGREGATE FUNCTION FAILS WITH ERROR 12403 WHEN EXECUTED VIA DATASERVER FOR ORACLE
可打印视图
信息
Article Number 000038909
Environment OpenEdge
10.x, 11.x
All Supported Operating Systems
Question/Problem Description
SQL query using aggregate function fails with error 12403 when executed via DataServer for Oracle.
SQL query is executed using RUN STORED-PROCEDURE SEND-SQL-STATEMENT ...
Column referenced by the aggregate function contains NULL values.
Dataserv.lg reports ORA-24347: Warning of a NULL column in an aggregate function.
Executing the same SQL query us