ORA-24347 Warning of a NULL column in an aggregate function Error
Hi, I'm recieving the following error:
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.
When issuing this query:
SELECT ALL SYS.DBA_SYS_PRIVS.GRANTEE, SYS.DBA_SYS_PRIVS.PRIVILEGE,
SYS.DBA_SYS_PRIVS.ADMIN_OPTION
FROM SYS.DBA_SYS_PRIVS
WHERE SYS.DBA_SYS_PRIVS.GRANTEE = :GRANTEE AND
SYS.DBA_SYS_PRIVS.PRIVILEGE = :PRIVILEGE
where GRANTEE = 'HOFFMANN' and PRIVILEGE = 'ALTER USER'
I expected the result to be 3 fields: HOFFMANN, ALTER USER, NO, but instead I go that error.
If I issue the same query for HOFFMANN, CREATE USER, then the query is successful and the result is HOFFMANN, CREATE USER, YES (because I have the Admin Option for that priviledge and I don't have the admin option for the Alter User priviledge).
I found the following "bug" was fixed in the 8.1.7.3 patch:
OCI 1087876 A spurious ORA-24347 may occur in OCI for statements not using aggregate functions.
So I applied the 8.1.7.4 patch, but either that wasn't the same bug or the patch didn't seem to help me. (We installed the 8.1.7.4 patch against the server so I thought it would be better to be in line with that patch.)
In case it matters I get the same error against an 8.1.7.4 database and 8.0.6 database using an 8.1.7.4 Client.
Oh, the queries all work fine through SQL Navigator. I only get the error when running it through our application using the OCI interface.
Can anyone offer any advice?
My email is Dawn.Hoffmann@ThomasTechSolutions.com
Thank you
Dawn