Page 1 of 1

ORA-24347: Warning of a NULL column in an aggregate function

Posted: Wed 09 Feb 2005 17:06
by benbahrenburg
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.

Re: ORA-24347: Warning of a NULL column in an aggregate function

Posted: Thu 10 Feb 2005 16:07
by Oleg
OraDirect .NET 3.0 doesn't have this problem by our tests. You can check it at your place and let us know if you have the problem. OraDirect .NET 3.0 release will be in about a month.

Posted: Wed 16 Feb 2005 17:04
by Guest
Does the 3.0 beta have full functionality or is it limited in number of rows returned?

Posted: Thu 17 Feb 2005 14:12
by Devart
Registered users can download OraDirect .NET 3.00 Beta version without trial restriction.