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

Reply via email to