ORA-24347: Warning of a NULL column in an aggregate function
Posted: Wed 09 Feb 2005 17:06
Hi,
Is there a fix for the ORA-24347: Warning of a NULL column in an aggregate function error generated when calling some SQL?
THis is an overflow error associated with out the OCI is called for 10g only. I sent support some articles and information a few months back. I was told this might be fixed in 3.0 is there an release date for 3.0 or the fix? I have a release date coming up soon and need this fix to meet my clients needs.
A good test SQL string to see if it is working correctly is the below.
SELECT ROLE "Role", PRIVILEGE "Privilege" , ADMIN_OPTION "With Admin Option" FROM ROLE_SYS_PRIVS ORDER BY 1,2
Please note this error is only generated in a 10g database.
Let me know if any additional information is needed.
Is there a fix for the ORA-24347: Warning of a NULL column in an aggregate function error generated when calling some SQL?
THis is an overflow error associated with out the OCI is called for 10g only. I sent support some articles and information a few months back. I was told this might be fixed in 3.0 is there an release date for 3.0 or the fix? I have a release date coming up soon and need this fix to meet my clients needs.
A good test SQL string to see if it is working correctly is the below.
SELECT ROLE "Role", PRIVILEGE "Privilege" , ADMIN_OPTION "With Admin Option" FROM ROLE_SYS_PRIVS ORDER BY 1,2
Please note this error is only generated in a 10g database.
Let me know if any additional information is needed.