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



From Duncan.Garland [...] motortrak.com Tue Dec 21 09: 05:47 2010
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=-0.001, BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5] autolearn=ham
X-Spam-Flag: NO
Acceptlanguage: en-US
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
Content-Language: en-US
Content-Type: multipart/alternative; boundary="_000_54D5B0EC76741A45859D634F05C5A1F40AE8CCF960mtkpdc01offic_"
Message-ID: <54D5B0EC76741A45859D634F05C5A1F40AE8CCF960 [...] mtkpdc01.office.motortrak.com>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-MS-Tnef-Correlator:
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id AC90F2412F4 for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Tue, 21 Dec 2010 09:05:47 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id iZE1ntaPjflO for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Tue, 21 Dec 2010 09:05:46 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 1AC922412E3 for <bug-DBIx-Class [...] rt.cpan.org>; Tue, 21 Dec 2010 09:05:43 -0500 (EST)
Received: (qmail 20983 invoked by uid 103); 21 Dec 2010 14:05:43 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 21 Dec 2010 14:05:43 -0000
Received: from ns0.motortrak.com (HELO iridium.motortrak.com) (194.145.147.194) by 16.mx.develooper.com (qpsmtpd/0.80) with SMTP; Tue, 21 Dec 2010 06:05:41 -0800
Received: (qmail 13062 invoked from network); 21 Dec 2010 14:05:37 -0000
Received: from unknown (HELO mtkpdc01.office.motortrak.com) (192.168.128.3) by iridium.motortrak.com with SMTP; 21 Dec 2010 14:05:37 -0000
Received: from mtkpdc01.office.motortrak.com ([192.168.128.3]) by mtkpdc01.office.motortrak.com ([192.168.128.3]) with mapi; Tue, 21 Dec 2010 14:05:36 +0000
Delivered-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
Subject: DBIx/Class/Storage/DBI/Oracle/Generic.pm
Return-Path: <Duncan.Garland [...] motortrak.com>
X-RT-Mail-Extension: dbix-class
X-Original-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
X-Spam-Check-BY: 16.mx.develooper.com
Thread-Index: AcuhGCML08sXpeNEQoyskrroFCuRgw==
Date: Tue, 21 Dec 2010 14:05:34 +0000
X-Spam-Level:
X-MS-Has-Attach:
Thread-Topic: DBIx/Class/Storage/DBI/Oracle/Generic.pm
Accept-Language: en-US
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: us-ascii
Content-Length: 875
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
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: us-ascii
Content-Length: 5163
MIME-Version: 1.0
In-Reply-To: <54D5B0EC76741A45859D634F05C5A1F40AE8CCF960 [...] mtkpdc01.office.motortrak.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <54D5B0EC76741A45859D634F05C5A1F40AE8CCF960 [...] mtkpdc01.office.motortrak.com>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-17549-1293131175-1328.64113-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 595
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
From Duncan.Garland [...] motortrak.com Fri Dec 24 06: 01:35 2010
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-17549-1293131175-727.64113-6-0 [...] rt.cpan.org>
X-Spam-Flag: NO
Acceptlanguage: en-US
References: <RT-Ticket-64113 [...] rt.cpan.org> <54D5B0EC76741A45859D634F05C5A1F40AE8CCF960 [...] mtkpdc01.office.motortrak.com> <rt-3.8.HEAD-17549-1293131175-727.64113-6-0 [...] rt.cpan.org>
Content-Language: en-US
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <54D5B0EC76741A45859D634F05C5A1F40AE8CCFDB5 [...] mtkpdc01.office.motortrak.com>
Content-Type: text/plain; charset="utf-8"
X-MS-Tnef-Correlator:
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 995C4241349 for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Fri, 24 Dec 2010 06:01:35 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id QjUVmY46YtdQ for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Fri, 24 Dec 2010 06:01:33 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 9B979241342 for <bug-DBIx-Class [...] rt.cpan.org>; Fri, 24 Dec 2010 06:01:32 -0500 (EST)
Received: (qmail 15512 invoked by uid 103); 24 Dec 2010 11:01:31 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 24 Dec 2010 11:01:31 -0000
Received: from ns0.motortrak.com (HELO iridium.motortrak.com) (194.145.147.194) by 16.mx.develooper.com (qpsmtpd/0.80) with SMTP; Fri, 24 Dec 2010 03:01:29 -0800
Received: (qmail 6021 invoked from network); 24 Dec 2010 11:01:14 -0000
Received: from unknown (HELO mtkpdc01.office.motortrak.com) (192.168.128.3) by iridium.motortrak.com with SMTP; 24 Dec 2010 11:01:14 -0000
Received: from mtkpdc01.office.motortrak.com ([192.168.128.3]) by mtkpdc01.office.motortrak.com ([192.168.128.3]) with mapi; Fri, 24 Dec 2010 11:01:14 +0000
Delivered-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm
Return-Path: <Duncan.Garland [...] motortrak.com>
Thread-Index: Acui1Hqw86+Cz6vmTcKql6nLnNB/cwAhRC/w
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbix-class
Date: Fri, 24 Dec 2010 11:01:13 +0000
X-Spam-Level:
Thread-Topic: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm
X-MS-Has-Attach:
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
Accept-Language: en-US
Content-Transfer-Encoding: base64
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
RT-Message-ID: <rt-3.8.HEAD-17551-1293188496-1985.64113-0-0 [...] rt.cpan.org>
Content-Length: 1085
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
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-17551-1293188496-1985.64113-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-64113 [...] rt.cpan.org> <54D5B0EC76741A45859D634F05C5A1F40AE8CCF960 [...] mtkpdc01.office.motortrak.com> <rt-3.8.HEAD-17549-1293131175-727.64113-6-0 [...] rt.cpan.org> <54D5B0EC76741A45859D634F05C5A1F40AE8CCFDB5 [...] mtkpdc01.office.motortrak.com> <rt-3.8.HEAD-17551-1293188496-1985.64113-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19315-1293191179-377.64113-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 424
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
MIME-Version: 1.0
In-Reply-To: <rt-3.8.HEAD-17551-1293188496-1985.64113-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <RT-Ticket-64113 [...] rt.cpan.org> <54D5B0EC76741A45859D634F05C5A1F40AE8CCF960 [...] mtkpdc01.office.motortrak.com> <rt-3.8.HEAD-17549-1293131175-727.64113-6-0 [...] rt.cpan.org> <54D5B0EC76741A45859D634F05C5A1F40AE8CCFDB5 [...] mtkpdc01.office.motortrak.com> <rt-3.8.HEAD-17551-1293188496-1985.64113-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-19311-1294305576-321.64113-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 397
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.
From Duncan.Garland [...] motortrak.com Thu Jan 6 10: 43:15 2011
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-3.8.HEAD-19311-1294305576-751.64113-6-0 [...] rt.cpan.org>
X-Spam-Flag: NO
Acceptlanguage: en-US
References: <RT-Ticket-64113 [...] rt.cpan.org> <54D5B0EC76741A45859D634F05C5A1F40AE8CCF960 [...] mtkpdc01.office.motortrak.com> <rt-3.8.HEAD-17549-1293131175-727.64113-6-0 [...] rt.cpan.org> <54D5B0EC76741A45859D634F05C5A1F40AE8CCFDB5 [...] mtkpdc01.office.motortrak.com> <rt-3.8.HEAD-17551-1293188496-1985.64113-6-0 [...] rt.cpan.org>,<rt-3.8.HEAD-19311-1294305576-751.64113-6-0 [...] rt.cpan.org>
Content-Language: en-GB
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <54D5B0EC76741A45859D634F05C5A1F40AE8D6E2F1 [...] mtkpdc01.office.motortrak.com>
Content-Type: text/plain; charset="utf-8"
X-MS-Tnef-Correlator:
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id AC39A241383 for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Thu, 6 Jan 2011 10:43:15 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id xbV9DnOD-nhr for <cpan-bug+DBIx-Class [...] hipster.bestpractical.com>; Thu, 6 Jan 2011 10:43:14 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id B0FC02412DC for <bug-DBIx-Class [...] rt.cpan.org>; Thu, 6 Jan 2011 10:43:13 -0500 (EST)
Received: (qmail 27870 invoked by uid 103); 6 Jan 2011 15:43:12 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 6 Jan 2011 15:43:12 -0000
Received: from ns0.motortrak.com (HELO iridium.motortrak.com) (194.145.147.194) by 16.mx.develooper.com (qpsmtpd/0.80) with SMTP; Thu, 06 Jan 2011 07:43:10 -0800
Received: (qmail 9606 invoked from network); 6 Jan 2011 15:43:06 -0000
Received: from unknown (HELO mtkpdc01.office.motortrak.com) (192.168.128.3) by iridium.motortrak.com with SMTP; 6 Jan 2011 15:43:06 -0000
Received: from mtkpdc01.office.motortrak.com ([192.168.128.3]) by mtkpdc01.office.motortrak.com ([192.168.128.3]) with mapi; Thu, 6 Jan 2011 15:43:06 +0000
Delivered-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm
Return-Path: <Duncan.Garland [...] motortrak.com>
Thread-Index: Acutgtgas5wmwprbQrKgTGMGjcYCCgANWLBW
X-Spam-Check-BY: 16.mx.develooper.com
X-Original-To: cpan-bug+DBIx-Class [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbix-class
Date: Thu, 6 Jan 2011 15:41:48 +0000
X-Spam-Level:
Thread-Topic: [rt.cpan.org #64113] DBIx/Class/Storage/DBI/Oracle/Generic.pm
X-MS-Has-Attach:
To: "bug-DBIx-Class [...] rt.cpan.org" <bug-DBIx-Class [...] rt.cpan.org>
Accept-Language: en-US
Content-Transfer-Encoding: quoted-printable
From: Duncan Garland <Duncan.Garland [...] motortrak.com>
RT-Message-ID: <rt-3.8.HEAD-9726-1294328596-1318.64113-0-0 [...] rt.cpan.org>
Content-Length: 818
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.