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

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

Postby benbahrenburg » 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.
benbahrenburg
 

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

Postby Oleg » Thu 10 Feb 2005 16:07

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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Postby Guest » Wed 16 Feb 2005 17:04

Does the 3.0 beta have full functionality or is it limited in number of rows returned?
Guest
 

Postby Devart » Thu 17 Feb 2005 14:12

Registered users can download OraDirect .NET 3.00 Beta version without trial restriction.
Devart
Devart Team
 
Posts: 3007
Joined: Tue 26 Oct 2004 13:51


Return to dotConnect for Oracle