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.
ORA-24347: Warning of a NULL column in an aggregate function
Re: ORA-24347: Warning of a NULL column in an aggregate function
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.