LMPX.COM |
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 |