CODEWITHSUNDEEP
databaseoracle-databasesqlplus
VINOTH ENERGETIC
VINOTH ENERGETIC

Reputation: 1853

Why warning message is not displayed when running query in query tool like sql* plus?

I got this in production and not able to reproduce the same warning message in testing platform.

The warning message I got is like 

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

Consider I am passing null column to aggregate function.

When I run the same query in query tool, I am not getting any warning message.

What is the rationale behind this?

Upvotes: 1

Views: 797

Answers (1)

VINOTH ENERGETIC
VINOTH ENERGETIC

Reputation: 1853

We are able to connect with oracle team. It is oracle bug and it is accepted by that team.

Upvotes: 1

Related Questions