develooper Front page | perl.dbi.users | Postings from August 2008

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

From:
jan_g_carlsson
Date:
August 13, 2008 12:23
Subject:
ORA-24347: Warning of a NULL column in an aggregate function
Message ID:
80dee4fe-2af1-4bd6-949a-dbda8c306def@d45g2000hsc.googlegroups.com
I'm getting ORA-24347 when calling a stored function which returns
a result set (REF CURSOR). The stored function contains a fairly
complicated query which uses COUNT() on a column (from an inline view)
which may contain NULL.
If I run the stored function from sqlplus it works fine but from
DBI/DBD::Oracle I get ORA-24347 which is regarded as an error despite
of it being an OCI_SUCCESS_WITH_INFO-message.
The problem has occurred recently when we upgraded to Oracle 10.2
(from 10.1).
I have tried to suppress the error using HandleError but without
success.

Is there a later version of DBI/DBD::Oracle which is working?

My environment is:

Oracle 10.2.0.4.0
Perl 5.8.8
DBI 1.52
DBD::Oracle 1.21
Linux




nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About