On Mon, May 02, 2005 at 02:41:34PM +0100, Charles Jardine wrote: > Oracle supports the use of select list expressions of type REF CURSOR. > These may be explicit cursor expressions - C<CURSOR(SELECT ...)>, or > calls to PL/SQL functions which return REF CURSOR values. The values > of these expressions are known as nested cursors. > > DBD::Oracle-1.16 does not support queries using nested cursors. > It produces the following reasonable warning message at (pre-)execute > time before dumping core at fetch time: > > Field [...] has an Oracle type (116) which is not explicitly supported > > The patch below adds support for these queries to DBD::Oracle.
Wow! That's wonderful. > This patch is against the 1.16 distribution. If it is deemed > acceptable in principle, I will be happy to re-work it against > the latest development version. That would be great. Ideally using subversion directly: http://search.cpan.org/~timb/DBD-Oracle/Oracle.pm#CONTRIBUTING In fact, if you give me your perl.org username (auth.perl.org), I'll add you as a committer - I'm trying to 'open up' the development some more so I'm less of a bottleneck... My only suggestion after a quick review would be to add some debug trace output at relevant places. Many thanks Charles! Tim.
