Bug #64113 for DBIx-Class: DBIx/Class/Storage/DBI/Oracle/Generic.pm

Tue Dec 21 09:05:48 2010 Duncan.Garland [...] motortrak.com - Ticket created

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>

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

Thu Dec 23 14:06:15 2010 ribasushi [...] leporine.io - Correspondence added

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

Thu Dec 23 14:06:16 2010 The RT System itself - Status changed from 'new' to 'open'

Fri Dec 24 06:01:36 2010 Duncan.Garland [...] motortrak.com - Correspondence added

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

Fri Dec 24 06:46:19 2010 ribasushi [...] leporine.io - Correspondence added

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

Thu Jan 06 04:19:36 2011 ribasushi [...] leporine.io - Correspondence added

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.

Thu Jan 06 04:19:37 2011 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'

Thu Jan 06 04:19:48 2011 ribasushi [...] leporine.io - Fixed in 0.08126 added

Thu Jan 06 10:43:16 2011 Duncan.Garland [...] motortrak.com - Correspondence added

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>

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.

Thu Jan 06 10:43:17 2011 The RT System itself - Status changed from 'resolved' to 'open'

Sun Jan 09 10:58:26 2011 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'