ORA-24347: Warning of a NULL column in an aggregate function解决方法

    前段时间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