Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 56810
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: alladdin [...] netsafe.cz
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 1.24a
Fixed in:
  • 1.25
  • 1.25-withoutworldwriteables
  • 1.25_brokentar
  • 1.26

Attachments


Subject: Multiple nested cursors causes sig-abort
Download (untitled) / with headers
text/plain 582b
Hello, I found a bug with multiple nested cursor in DBD::Oracle 1.24a. Causes sig-abort when fetching outer cursor. Problem is with fetching something like this: SELECT object_name, CURSOR(SELECT object_name FROM dual) CURSOR(SELECT object_name FROM dual) FROM all_objects WHERE rownum <= 5 I made modification in the test 55nested.t and I attach a diff for it. I tried it on two perl versions (and two systems): This is perl, v5.10.1 (*) built for MSWin32-x86-multi-thread This is perl, v5.10.0 built for i686-linux Thanks. Ladislav Dokulil (Alladdin)
Subject: multiple_nested_cursors_test.diff
Index: t/55nested.t =================================================================== --- t/55nested.t (revision 13910) +++ t/55nested.t (working copy) @@ -27,7 +27,9 @@ # 10.2.0.1 (Base Release) my $outer = $dbh->prepare(q{ - SELECT object_name, CURSOR(SELECT object_name FROM dual) + SELECT object_name, + CURSOR(SELECT object_name FROM dual) + CURSOR(SELECT object_name FROM dual) FROM all_objects WHERE rownum <= 5}); ok($outer, 'prepare select');
Download (untitled) / with headers
text/plain 243b
Ok I fixed this seem nested cursors do not like multiple fetches so I fixed that on oci8.c and I also expanded the 55 test so it will now check for multiple cursors you can find the fixed code here http://svn.perl.org/modules/dbd-oracle/trunk


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.