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)



Subject: Errors if a returned SYS_REFCURSOR is not opened
Download (untitled) / with headers
text/plain 645b
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
Download (untitled) / with headers
text/plain 885b
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
Download (untitled) / with headers
text/plain 135b
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
Download (untitled) / with headers
text/plain 311b
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)
Aaaand there we go. v1.58 on its way to CPAN. Enjoy!
Download (untitled) / with headers
text/plain 192b
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
Download (untitled) / with headers
text/plain 362b
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
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>
Download (untitled) / with headers
text/plain 296b
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 -- --


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.