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: 82663
Status: resolved
Priority: 0/
Queue: DBD-Oracle
People
Owner: Nobody in particular
Requestors: bohica [...] ntlworld.com
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: 1.56
Fixed in: (no value)

History Show all quoted text
  Sat Jan 12 12:21:44 2013 bohica [...] ntlworld.com - Ticket created
Subject: Errors if a returned SYS_REFCURSOR is not opened
This issue probably applies to a lot of DBD::Oracle release before 1.56 as well. If you create this proc: procedure p_n2(pcur OUT SYS_REFCURSOR) AS begin pcur := NULL; end; and then do: my $s = $h->prepare(q/begin mypkg.p_n2(?); end;/); $s->bind_param_inout(1, \my $cursor, 100, {ora_type => ORA_RSET}); $s->execute; # errors it errors on an OCIAttrGet for PARAM_COUNT when attempting to dbd_describe the new cursor. This means if you have a function or procedure which does not always return an opened cursor you are stuck. See dbi-dev list for a discussion of possible solutions. Martin -- Martin J. Evans Wetherby, UK
  Tue Jan 15 18:44:43 2013 bohica [...] ntlworld.com - Correspondence added
On Sat Jan 12 12:21:44 2013, MJEVANS wrote: Show quoted text
> This issue probably applies to a lot of DBD::Oracle release before 1.56 > as well. > > If you create this proc: > > procedure p_n2(pcur OUT SYS_REFCURSOR) AS > begin > pcur := NULL; > end; > > and then do: > > my $s = $h->prepare(q/begin mypkg.p_n2(?); end;/); > $s->bind_param_inout(1, \my $cursor, 100, {ora_type => ORA_RSET}); > $s->execute; # errors > > it errors on an OCIAttrGet for PARAM_COUNT when attempting to > dbd_describe the new cursor. This means if you have a function or > procedure which does not always return an opened cursor you are stuck. > > See dbi-dev list for a discussion of possible solutions. > > Martin
Ongoing discussion at http://www.mail-archive.com/dbi-dev@perl.org/msg06963.html where I've proposed 2 patches but there are complications. Martin -- Martin J. Evans Wetherby, UK
  Tue Jan 15 18:44:45 2013 bohica [...] ntlworld.com - Status changed from 'new' to 'open'
  Tue Mar 05 05:45:07 2013 bohica [...] ntlworld.com - Correspondence added
Should be fixed in 1.57_00 now. Just waiting for Yanick to get around to an official release. Martin -- Martin J. Evans Wetherby, UK
  Tue Mar 05 05:46:31 2013 bohica [...] ntlworld.com - Status changed from 'open' to 'patched'
  Tue Mar 05 10:17:59 2013 champoux [...] pythian.com - Correspondence added
On Tue Mar 05 05:45:07 2013, MJEVANS wrote: Show quoted text
> Should be fixed in 1.57_00 now. Just waiting for Yanick to get around to > an official release.
Sorry. I'm on a medical leave of 2 weeks. But since the dev release has been soaked for more than the prescribed fortnight... let's see what I can do... (stay tuned)
  Tue Mar 05 10:18:00 2013 The RT System itself - Status changed from 'patched' to 'open'
  Tue Mar 05 10:37:27 2013 champoux [...] pythian.com - Correspondence added
Aaaand there we go. v1.58 on its way to CPAN. Enjoy!
  Fri May 03 16:14:07 2013 champoux [...] pythian.com - Correspondence added
On Tue Mar 05 10:37:27 2013, PYTHIAN wrote: Show quoted text
> Aaaand there we go. v1.58 on its way to CPAN. > > Enjoy!
Can somebody confirms (or disproves) that the problem went away with 1.58+ ? `/anick
  Tue May 07 08:19:38 2013 bohica [...] ntlworld.com - Correspondence added
On Fri May 03 16:14:07 2013, PYTHIAN wrote: Show quoted text
> On Tue Mar 05 10:37:27 2013, PYTHIAN wrote:
> > Aaaand there we go. v1.58 on its way to CPAN. > > > > Enjoy!
> > Can somebody confirms (or disproves) that the problem went away with 1.58+ ? > > > `/anick
I reported it and I fixed it so naturally I think it is fixed ;-) Martin -- Martin J. Evans Wetherby, UK
  Tue May 07 10:48:38 2013 champoux [...] pythian.com - Correspondence added
Subject: Re: [rt.cpan.org #82663] Errors if a returned SYS_REFCURSOR is not opened
Date: Tue, 07 May 2013 10:48:19 -0400
To: bug-DBD-Oracle [...] rt.cpan.org
From: Yanick Champoux <champoux [...] pythian.com>
On 13-05-07 08:19 AM, Martin J Evans via RT wrote: Show quoted text
> I reported it and I fixed it so naturally I think it is fixed;-)
You have better faith in your skills than I have in mine (but then, that's probably due to a fair assessment of said skills in both our cases). ;-) Joy, `/anick -- --
  Tue May 07 10:49:02 2013 champoux [...] pythian.com - Status changed from 'open' to 'resolved'