Home  |  Linux  | Mysql  | PHP  | XML
From:jan_g_carlsson@yahoo.se Date:Tue Aug 12 23:27:54 2008
Subject:ORA-24347: Warning of a NULL column in an aggregate function
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

Navigate in group perl.dbi.users at sever nntp.perl.org
Previous Next




  
© No Copyright
You are free to use Anything
Site Maintained by PHP Developer
Powered By PHP Consultants