Skip Menu |
 

This queue is for tickets about the DBIx-Class CPAN distribution.

Report information
The Basics
Id: 64113
Status: resolved
Priority: 0/
Queue: DBIx-Class

People
Owner: Nobody in particular
Requestors: Duncan.Garland [...] motortrak.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 0.08126



Subject: DBIx/Class/Storage/DBI/Oracle/Generic.pm
Date: Tue, 21 Dec 2010 14:05:34 +0000
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Download (untitled) / with headers
text/plain 875b
Hi, I've been bitten a couple of times recently by the following error: "Unable to find a sequence %INSERT% trigger on table '$source_name'." The code is looking for an insert trigger in which the sequence's next value is selected using a statement with the following structure: SELECT s_mbfl2_services_bookedi.NEXTVAL INTO :new.id FROM dual; It fails if you select into an intermediate variable: SELECT s_mbfl2_services_booked.NEXTVAL INTO x FROM dual; In most cases the former is tidier code and I suppose both statement could go in the same trigger if necessary: SELECT s_mbfl2_services_booked.NEXTVAL INTO :new.id FROM dual; SELECT s_mbfl2_services_booked.CURRVAL INTO x FROM dual; However, would it be possible to have an error message which makes it clearer why the error has occurred? I had to read the source code to work it out. All the best. Duncan
Download (untitled) / with headers
text/plain 595b
On Tue Dec 21 09:05:48 2010, Duncan.Garland@motortrak.com wrote: Show quoted text
> Hi, > > I've been bitten a couple of times recently by the following error: > > "Unable to find a sequence %INSERT% trigger on table '$source_name'." > > The code is looking for an insert trigger in which the sequence's next > value is selected using a statement with the following structure: > > SELECT s_mbfl2_services_bookedi.NEXTVAL INTO :new.id FROM dual;
Not anymore. Can you please test the current master branch, see if it makes all of your issues go away? git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git Cheers
Subject: RE: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm
Date: Fri, 24 Dec 2010 11:01:13 +0000
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Hi Peter, Thanks for doing that. Do I need git to test it? We're not really set up to test CPAN modules here. If it's simple to do then I might be able to help. Regards Duncan Show quoted text
-----Original Message----- From: Peter Rabbitson via RT [mailto:bug-DBIx-Class@rt.cpan.org] Sent: 23 December 2010 19:06 To: Duncan Garland Subject: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm <URL: https://rt.cpan.org/Ticket/Display.html?id=64113 > On Tue Dec 21 09:05:48 2010, Duncan.Garland@motortrak.com wrote:
> Hi, > > I've been bitten a couple of times recently by the following error: > > "Unable to find a sequence %INSERT% trigger on table '$source_name'." > > The code is looking for an insert trigger in which the sequence's next > value is selected using a statement with the following structure: > > SELECT s_mbfl2_services_bookedi.NEXTVAL INTO :new.id FROM dual;
Not anymore. Can you please test the current master branch, see if it makes all of your issues go away? git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git Cheers
Download (untitled) / with headers
text/plain 424b
On Fri Dec 24 06:01:36 2010, Duncan.Garland@motortrak.com wrote: Show quoted text
> Hi Peter, > > Thanks for doing that. > > Do I need git to test it? We're > not really set up to test CPAN modules here. If it's simple to do then > I might be able to help. >
Very simple: git clone git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git dir_of_your_choice export PERL5LIB="dir_of_your_choice/lib:$PERL5LIB" run whatever tests you want to run
Download (untitled) / with headers
text/plain 397b
On Fri Dec 24 06:01:36 2010, Duncan.Garland@motortrak.com wrote: Show quoted text
> Hi Peter, > > Thanks for doing that. > > Do I need git to test it? We're > not really set up to test CPAN modules here. If it's simple to do then > I might be able to help. >
We are pretty confident this issue has been resolved in 0.08126, thus marking this ticket as fixed. Please feel free to reopen if the problem persists.
Subject: RE: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm
Date: Thu, 6 Jan 2011 15:41:48 +0000
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Download (untitled) / with headers
text/plain 818b
Hi Peter, I wasn't able to organise a special version to test, but I'm sure it's fine. I'll let you know if I discover otherwise. Thanks Duncan Show quoted text
________________________________________ From: Peter Rabbitson via RT [bug-DBIx-Class@rt.cpan.org] Sent: 06 January 2011 09:19 To: Duncan Garland Subject: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm <URL: https://rt.cpan.org/Ticket/Display.html?id=64113 > On Fri Dec 24 06:01:36 2010, Duncan.Garland@motortrak.com wrote:
> Hi Peter, > > Thanks for doing that. > > Do I need git to test it? We're > not really set up to test CPAN modules here. If it's simple to do then > I might be able to help. >
We are pretty confident this issue has been resolved in 0.08126, thus marking this ticket as fixed. Please feel free to reopen if the problem persists.


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.