Charles Jardine wrote:
1. ora_max_nested_cursors is not relevant. This value is used
only in the case where a result set has columns of type REF CURSOR,
resulting in nested fetches. If you don't have a 'CURSOR( ... )'
expression in the select list of a 'SELECT' statement, you don't
On 19/01/07 18:07, Joel Noble wrote:
Hello, all!
I'm having slow performance reading from a cursor that is returned
from a stored procedure. Network tracing and strace confirms that
a round-trip is being done to the Oracle DB to fetch each row, with no
pre-caching. Using DBI-1.52,
Hello, all!
I'm having slow performance reading from a cursor that is returned from a
stored procedure. Network tracing and strace confirms that a round-trip is
being done to the Oracle DB to fetch each row, with no pre-caching. Using
DBI-1.52, DBD-Oracle-1.18 on Linux with Perl 5.8.5 and
