Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

332210Aug 30 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2002
Added on Aug 30 2002
2 comments
2,085 views