Fwd: please help with DBD-Oracle-1.76

> Begin forwarded message: > > From: Daniel Chmielewski > Subject: Fwd: please help with DBD-Oracle-1.76 > Date: 5 September 2022 at 10:03:15 IST > To: t...@cpan.org > > Tim, please help. > Regards, > Daniel > > > -- Forwarded message - > Od: Daniel Chmielewski

(Fwd) DBD:Oracle

- Forwarded message from Ajay Kumar - Date: Mon, 13 Jul 2020 15:32:55 + From: Ajay Kumar To: Tim Bunce Subject: DBD:Oracle Hi Tim, Hope, you are sound and safe with your loved ones. I am trying to install the ORA2PG tool which migrates Oracle data into PostgreSQL

Announce: DBI 1.643

=head2 Changes in DBI 1.643 - 31st January 2020 Fix memory corruption in XS functions when Perl stack is reallocated thanks to Pali Fix calling dbd_db_do6 API function thanks to Pali Fix potentially calling newSV(0) in malloc_using_sv() thanks to Pali Fix

Announce: DBI 1.642

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.642.tar.gz size: 604581 bytes md5: f2ba18b5cea1c8cb322a62be0a847f3d sha1: 4838da411896707eb89acf63ae2d35c88ff841c7 =head2 Changes in DBI 1.642 - 28th October 2018 Fix '.' in @INC for proxy test under parallel load thanks to H.Merijn

Re: Extend API for last_insert_id

On Fri, May 04, 2018 at 02:10:18PM +0200, p...@cpan.org wrote: > Hello, do you have any opinion or comments? > > Tim, you as a DBI maintainer, what do you think about those ideas? > > On Friday 27 April 2018 16:03:59 p...@cpan.org wrote: > > > > So I'm proposing change that caller would be

Re: debugging and stepping into ->do

On Wed, Apr 25, 2018 at 06:34:20PM +, Jeff Macdonald wrote: >Thanks Brian! >I'm familiar with C. My goal with digging into DBI was to programmatically > cause a SQL error in a test >case. I needed somehow to create a wrapper around do (or execute) in which > I'd examine the

Announce DBI-1.640

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.640.tar.gz size: 603787 bytes md5: 47d37079ba164908a65fb86f8179cb74 sha1: 2446ea4e139cd56c66f1dd99c58536fa3f4e97cc =head2 Changes in DBI 1.640 - 28th January 2018 Fix test t/91_store_warning.t for perl 5.10.0 thanks to pali #57 Add

Re: Need help with an unexpected behaviour

On Fri, Jan 26, 2018 at 04:47:35PM +0100, Andreas Mock wrote: > Hi all, > > 9 my %attr = ( > 10 'AutoCommit' => 1, > 11 'RaiseError' => 1, > 35 sub doit { > 36 my $dbh = shift; > 37 > 38 local $dbh->{'AutoCommit'} = 1; > 39 > 40 $dbh->begin_work; > 41

Announce: DBI 1.639

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.639.tar.gz size: 603697 bytes md5: f9bf9775b3dbaabc4630b2b29941aa89 sha1: d486ad357708054827017a0d7151554704ce6607 =head2 Changes in DBI 1.639 - 28th December 2017 Fix UTF-8 support for warn/croak calls within DBI internals, thanks to

Re: Oracle encoding query

On Wed, Dec 06, 2017 at 04:53:36PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:34:17 +0000, Tim Bunce <tim.bu...@pobox.com> > wrote: > > > A view might be useful. Or perhaps define your own function to wrap the > > expression. > > That worked very well

Re: Oracle encoding query

On Wed, Dec 06, 2017 at 04:12:53PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:50:11 +0100, "H.Merijn Brand" > > > > I have been playing with several variants of > > > > select convert (land_u, 'AL16UTF16', 'UTF8') from land where c_land = > > 7072; > > > > but I didn't get SQL

Announce: DBI 1.637

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.637.tar.gz size: 596423 bytes md5: fdcb1739c923300de7bc5250c1c75337 sha1: 183ba1542a7499b508568c1765a4a1bcc4b4bbc9 =head2 Changes in DBI 1.637 Fix use of externally controlled format string (CWE-134) thanks to pali #44 This could cause

(Fwd) Oracle.pm

- Forwarded message from Gowtham - Date: Mon, 6 Mar 2017 15:40:59 -0600 From: Gowtham To: tim.bu...@pobox.com Subject: Oracle.pm Hi Tim, I feel that you are the right person to check this with. I am trying to understand the

Re: FetchHashKeyName emits invalid keys for utf8 fieldnames

Thanks for the report Chris. Any chance you could write up a small test case for us? Ideally in a new issue at https://github.com/perl5-dbi/dbi/issues Thanks. Tim. On Fri, Feb 24, 2017 at 12:55:23PM +1100, Chris Hutchinson wrote: > Using DBI v 1.636 > > $dbi->{FetchHashKeyName}=’NAME_lc’ or

(Fwd) RE: Issues with Oracle DBD in Cygwin

- Forwarded message from "Neargarder, Keith" - Date: Wed, 12 Oct 2016 12:22:00 + From: "Neargarder, Keith" To: "'t...@cpan.org'" , "'byter...@cpan.org'" ,

Re: sth->prepare() setting Active?

Looks good. Thanks David! Tim. On Fri, Sep 30, 2016 at 04:03:35PM -0500, David Nicol wrote: > sorry, this one is better > >"Active" > >Type: boolean, read-only > >The "Active" attribute is true if the handle object is "active". This >is rarely used in

Re: sth->prepare() setting Active?

On Fri, Sep 30, 2016 at 12:40:02AM +0100, Russell Howe via dbi-users wrote: > On Thu, Sep 29, 2016 at 11:30:08PM -, Greg Sabino Mullane wrote: > > > > > Should a call to prepare() return an Active statement? (i.e. > > > $sth->{Active} == 1) > > > > > > This appears to be the behaviour of

(Fwd) Issues with Oracle DBD in Cygwin

- Forwarded message from "Neargarder, Keith" - Date: Fri, 16 Sep 2016 22:16:11 + From: "Neargarder, Keith" To: "'t...@cpan.org'" , "'byter...@cpan.org'" ,

Re: DBD::XML

On Sun, Sep 04, 2016 at 08:33:21AM -0400, Nigel Horne wrote: > > On 4/9/16 05:56, Tim Bunce wrote: > > > So here's an interesting one. Any thoughts on this? I assumed it all got > > > pulled in magically, but I guess I'm missing something. But what? > > > >

Re: DBD::XML

On Thu, Sep 01, 2016 at 01:53:52PM -0400, Nigel Horne wrote: > So here's an interesting one. Any thoughts on this? I assumed it all got > pulled in magically, but I guess I'm missing something. But what? > > http://www.cpantesters.org/cpan/report/f9cbd816-7052-11e6-ab41-c893a58a4b8c I've not

Re: DBD::XML

On Sun, Aug 21, 2016 at 02:29:49PM -0400, Nigel Horne wrote: > > > Anyway, back to the topic of naming... I'd suggest something like > > DBD::XMLSimpleTable which would have a corresponding prefix of 'xmlst_'. > > Not so sure about Table - how about DBD::XMLSimple? Yeap. That seems fine. So

Re: DBD::XML

On Fri, Aug 19, 2016 at 10:09:45AM -0400, Nigel Horne wrote: > On 8/19/16 9:56 AM, Tim Bunce wrote: > > On Fri, Aug 19, 2016 at 09:30:32AM -0400, Nigel Horne wrote: > > > > > > Apart from one change I need to make in terms of column names, I'm pretty > > > m

Re: DBD::XML

On Fri, Aug 19, 2016 at 09:30:32AM -0400, Nigel Horne wrote: > Ron, > > > I've started working on a DBD::XML driver, and the first pass is looking > > > good. I'm doing this because of the demise of DBD::AnyData, and > > > DBD::AnyData2 isn't ready yet, so until it is I wanted XML support. > > >

(Fwd) DBD::Oracle quote_identifier

- Forwarded message from "LAWS, MICHAEL H" - Date: Tue, 16 Aug 2016 21:04:20 + From: "LAWS, MICHAEL H" To: "t...@cpan.org" Subject: DBD::Oracle quote_identifier Hello, I was using quote_identifier for table names on an oracle

Re: suppress quoting in prepared sql

I'd happily take a patch to the DBI docs to mention the common use case described by this thread. Tim. On Tue, Apr 05, 2016 at 05:29:34PM +, Vaughan, Mark wrote: > This works if the number of elements remains static. You'd have to run the > prepare again if the number of elements changes. >

(Fwd) perl DBI bug report

- Forwarded message from Dave Dyer - Date: Tue, 01 Sep 2015 12:40:00 -0700 From: Dave Dyer To: tim.bu...@pobox.com Subject: perl DBI bug report This query produces results with lots of trailing nulls embedded in the "outcome" value. I suppose

Announce: DBI 1.634

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.634.tar.gz size: 595020 bytes md5: 4ad15a9c2cc9b68e3fe1f5cadf9cdb30 =head2 Changes in DBI 1.634 - 3rd August 2015 Enabled strictures on all modules (Jose Luis Perez Diez) #22 Note that this might cause new exceptions in existing code.

Please test DBI-1.633_91 - recently uploaded to CPAN

I've uploaded DBI-1.633_91 to CPAN. It contains a couple of experimental changes I'd like feedback on: https://metacpan.org/changes/release/TIMB/DBI-1.633_91 Enabled strictures on all modules (Jose Luis Perez Diez) #22 Note that this might cause new exceptions in existing code.

Re: Potential dbi memory leak.

On Thu, May 28, 2015 at 03:59:51PM +1200, Duncan McEwan wrote: On Tue, 26 May 2015 14:13:05 +0100 Tim Bunce tim.bu...@pobox.com wrote: I've added this as a note: Note that the ChildHandles array holds weak references and that 'from time to time' the old slots get freed up

Re: Potential dbi memory leak.

I've added this as a note: Note that the ChildHandles array holds weak references and that 'from time to time' the old slots get freed up. This isn't a leak, it just appears to be if you're not familiar with the caching that DBI does internally. You can rest assured that if the

Re: Making DBD::Pg to return Postgres arrays as Perl arrays

On Thu, May 07, 2015 at 01:30:45PM +0200, Adam Sjøgren wrote: I wrote: When I insert new rows where the field has a Perl-array as the value, DBIx::Class+DBD::Pg automatically stores them in the database, as hoped - nice! But when I read the field again, I get the textual

Re: May CPAN Pull request chalenge

On Fri, May 01, 2015 at 06:34:58PM +0200, jl...@escomposlinux.org wrote: Hi Tim, Hi! I have got as a May a assignment your module DBI. Congratulations :) In Neil's message he sugested 3 areas for the pull request: Notes on your distribution: * It has a file 'test.pl' in the top

Re: DESTROY ignored for outer handle

On Tue, Apr 28, 2015 at 8:09 PM, Tim Bunce [1]tim.bu...@pobox.com wrote: On Tue, Apr 28, 2015 at 09:16:48AM +0300, Nikos Vaggalis wrote: Now,when in the same session, the error does not occur no matter how much I stress it. When opening another 4-5 sessions

Re: DESTROY ignored for outer handle

On Tue, Apr 28, 2015 at 09:16:48AM +0300, Nikos Vaggalis wrote: Now,when in the same session, the error does not occur no matter how much I stress it. When opening another 4-5 sessions,or doing a couple of reloads of the same session, the following DBI error comes up : I don't see

Re: DBD::ODBC Destroy bug?

On Wed, Apr 01, 2015 at 03:20:31PM +0100, Martin J. Evans wrote: However, having said all that I didn't see you were using freeTDS until the last email. I've seen an issue with freeTDS returning and error status and then not supplying the reason before. I have to say at this point I'm

Re: Perl 6 and DBI

On Thu, Feb 05, 2015 at 12:23:40AM -, Greg Sabino Mullane wrote: As you may have heard, Larry Wall gave a speech recently declaring the goal of releasing Perl 6 this year, 2015. Honestly, there is little chance of me using Perl 6 until it has a good, working DBI. Anyone know the state

Re: Escaping placeholders, take 2

On Fri, Jan 09, 2015 at 02:54:56PM -, Greg Sabino Mullane wrote: Just a heads up to this list - support for backslash-escaped placeholders is now implemented in the current production version of DBD::Pg, 3.5.0 http://search.cpan.org/dist/DBD-Pg/

Re: make test fails installing DBI-1.632 (linux, perl5.8.8)

On Wed, Jan 07, 2015 at 04:50:52PM -0500, John Wiersba wrote: I see in META.{json,yaml} that a later version of Test::Simple is required, but that doesn't seem to cause a noticable error message or abort the Makefile.PL/make/make test process. Installing the latest version of Test::Simple

Re: Escaping placeholders, take 2

On Wed, Dec 31, 2014 at 03:55:42AM -, Greg Sabino Mullane wrote: Tim Bunce wrote: Wherein I attempt to summarize the requirements, the background, the options, the risks, and the counter-proposal ... Thanks for taking the time to write all this out in a coherent manner. You're

Escaping placeholders, take 2

Wherein I attempt to summarize the requirements, the background, the options, the risks, and the counter-proposal ... ** Background Drivers that support placeholders parse the SQL statement to find them. The parsing is really just simple tokenization that only knows how to skip over quoted

Re: Escaping placeholders (was: [Dbix-class] Using Postgres JSONB operators in queries)

Sometime over the holiday period I hope to write up a summary of the arguments for and against and suggest ways forwards. Tim.

Re: Escaping placeholders

, if they want to. (The DBI has a built-in preparse function that's intended for parsing placeholders but few, if any, drivers use it. I know DBD::Informix doesn't.) Tim. On Sat, Dec 20, 2014 at 2:17 PM, Tim Bunce [2]tim.bu...@pobox.com wrote: On Sat, Dec 20, 2014 at 01:14:29PM -0800

Re: Escaping placeholders

On Sun, Dec 21, 2014 at 10:27:18AM +0100, pe...@vanroose.be wrote: On 20.12.2014 15:38, Tim Bunce wrote: [...] Can you, or anyone else, think of any situation where a backslash before a ? or :foo (or even $1) style placeholder might be valid SQL? Inside quoted text: of course, yes

Re: Escaping placeholders

Thanks David :) Tim. On Fri, Dec 19, 2014 at 12:23:23PM -0600, David Nicol wrote: Please disregard my previous. After reading Tim Bunce's earlier response and thinking about this some more, although backslash escaping can be tricky, that is how Perl does these things, and Perl coders

Re: Escaping placeholders

On Fri, Dec 19, 2014 at 01:12:16PM +0100, Alexander Foken wrote: Hello all, this reminds me of a similar problem I had in 2000 with DBI, DBD::Oracle, and Oracle. See http://marc.info/?t=9506395904r=1w=2, http://173.79.223.25/?l=dbi-devm=95077716125217w=2. Problem was using named

Re: Escaping placeholders

On Sat, Dec 20, 2014 at 05:35:55PM +0100, Alexander Foken wrote: On 20.12.2014 15:38, Tim Bunce wrote: Can you, or anyone else, think of any situation where a backslash before a ? or :foo (or even $1) style placeholder might be valid SQL? I found two situations for PostgreSQL: (1

Re: Escaping placeholders

On Sat, Dec 20, 2014 at 01:14:29PM -0800, Jonathan Leffler wrote: Many, many years ago, DBD::Informix had to give up on the DBI-provided parsing for placeholders because there were too many contexts in which it was wrong for Informix. It may have improved since then, but:

Escaping placeholders (was: [Dbix-class] Using Postgres JSONB operators in queries)

Hello Augustus. On Thu, Dec 04, 2014 at 03:38:14PM -0800, Augustus Saunders wrote: Hi all, I have been unable to find a way to use some of the new JSONB operators in Postgres 9.4 with DBIx::Class. A quick search for JSONB on the email archive site didn't turn up any results, so I

Re: First time DBI user crashing perl

Turning on tracing is usually a good idea when odd things are happening. Read https://metacpan.org/pod/DBI#TRACING and set the DBI_TRACE environment variable. Tim. On Wed, Oct 29, 2014 at 09:56:27PM -0600, Jon wrote: Hello Peter, Well, that's kinda what I figured but never hurts try

Re: First time DBI user crashing perl

On Thu, Oct 30, 2014 at 03:33:05PM -0500, Peter Shabino wrote: Here is the environment variables: env DB2INSTANCE = DB2 env DB2LIB = C:/Program Files/IBM/SQLLIB/lib/Win32 env LD_LIBRARY_PATH = C:/Program Files/IBM/SQLLIB/lib/Win32 env LIBPATH = C:/Program

Re: Using DBI::Profile to count and time database calls

Sorry for the delay. On Tue, Oct 07, 2014 at 12:00:31PM -0700, Bill Moseley wrote: Noting like writing an email to trigger reading the docs again. :) On Tue, Oct 7, 2014 at 11:43 AM, Bill Moseley [1]mose...@hank.org wrote: I'm trying to just count number of database queries and

Re: DBI Mysql Driver Handle Mysteriously Changes!

On Thu, Mar 27, 2014 at 04:43:41PM +1300, Duncan McEwan wrote: I've got 1000's of lines of debugging showing this happening. Some of it is my own, inserted as print statements or cluck calls directly into DBI.pm and some of it the standard DBI debugging set to level 9. There is

Re: DBI Mysql Driver Handle Mysteriously Changes!

Hello Duncan. On Tue, Mar 25, 2014 at 04:42:56PM +1300, Duncan McEwan wrote: First, a brief recap. We have a web-based application that runs as a FosWiki plugin under Apache/fcgid. Could you post the fcgid configuration details for us? https://httpd.apache.org/mod_fcgid/mod/mod_fcgid.html

Re: PostgreSQL driver DBD::Pg releases version 3.0.0

On Thu, Feb 06, 2014 at 12:30:15PM +1100, Ron Savage wrote: Eg: map{($_ = encode('utf-8', $$hashref{$_}) )} keys %$hashref $$item{$_} = decode('utf-8', $$item{$_} || '') for keys %$item Performance tip: using the function form of encode() and decode() is significantly slower than using the

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

On Fri, Jan 31, 2014 at 09:11:28AM -0500, John Scoles wrote: A final note on this. Seems there was a very very long unknown bug in DBI which was only fix a few days ago wiht DB 1.6.31 If you mean Callbacks getting an inner handle, that wasn't a bug as such. More like a design choice

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

To: tim.bu...@pobox.com; byter...@hotmail.com CC: hhferre...@gmail.com; boh...@ntlworld.com; dbi-users@perl.org Subject: Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE) On 31/01/14 16:21, Tim Bunce wrote: On Fri, Jan 31, 2014 at 09:11:28AM -0500, John Scoles

Announce: DBI 1.631

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.631.tar.gz size: 589096 bytes md5: 444d3c305e86597e11092b517794a840 =head2 Changes in DBI 1.631 - 20th Jan 2014 NOTE: This release changes the handle passed to Callbacks from being an 'inner' handle to being an 'outer' handle. If you have code that

Re: DBI: selectrow_array() return first column when called in list context

On Mon, Dec 23, 2013 at 09:30:22AM +, mimic...@gmail.com wrote: The SQL query is the same in both cases, and as can be seen, the query is expected to return two columns (user and perm), but selectrow_array() returns undef for the second column (perm in this case). my ($x, $y)

(Fwd) Problems with DBD::Oracle package: function plsql_errstr

- Forwarded message from Eljot na Onet.pl eljot_...@poczta.onet.pl - Date: Sat, 02 Nov 2013 21:11:48 +0100 From: Eljot na Onet.pl eljot_...@poczta.onet.pl To: t...@cpan.org Subject: Problems with DBD::Oracle package: function plsql_errstr Hi, I have found two problems with your

Please test DBI-1.628_50 re change in PrintWarn

The PrintWarn attribute used to default to the same value as $^W. In other words, if you ran perl with -w then would be on. See https://metacpan.org/module/TIMB/DBI-1.627/DBI.pm#PrintWarn That was reasonable back in early 2004 when PrintWarn was added to the DBI. I'm planning to change

Re: Please test DBI-1.628_50 re change in PrintWarn

this trial version, then you'll need to recompile your drivers again. Sorry for the inconvenience!) Tim. On Fri, Oct 11, 2013 at 01:49:04PM +0100, Tim Bunce wrote: The PrintWarn attribute used to default to the same value as $^W. In other words, if you ran perl with -w then would be on. See

(Fwd) Can't use an undefined value as an ARRAY reference at /usr/local/lib/perl/5.14.2/DBI.pm

- Forwarded message from Yonatan Sisay ysi...@cloudxdpo.com - Date: Sat, 28 Sep 2013 01:25:04 -0700 From: Yonatan Sisay ysi...@cloudxdpo.com To: tim.bu...@pobox.com Subject: Greetings, I have been having an issue with DBI. I installed a web system called KOHA, and in the middle

Re: DBD::mysql 4.024 released, many fixes, especially for Windows

I'm delighted to see DBD::mysql moving again. Many thanks to you and all those actively contributing their time, attention and energy. Tim. On Wed, Sep 18, 2013 at 08:52:25AM +0200, Michiel Beijen wrote: Patrick Galbraith has released a new version of DBD::mysql with many small fixes inside.

Re: using callbacks with connect_cached

Both merged. Thanks! Tim. On Tue, Sep 03, 2013 at 11:07:15AM -0700, David E. Wheeler wrote: On Aug 25, 2013, at 12:10 PM, Tim Bunce tim.bu...@pobox.com wrote: p.s. I'd be delighted to get a doc patch that notes the need to use a lexical for the callbacks hashref on connect_cached

(Fwd) DBD::Gofer

- Forwarded message from reist87 reis...@gmail.com - Date: Mon, 26 Aug 2013 17:31:11 +0600 From: reist87 reis...@gmail.com To: tim.bu...@pobox.com Subject: DBD::Gofer Hi, Tim. Sorry for my English, I am russian) We have program on consumer computer, which connected to MS SQL

Re: using callbacks with connect_cached

On Sun, Aug 25, 2013 at 01:38:57PM +0200, David E. Wheeler wrote: On Aug 24, 2013, at 9:40 PM, Vincent Veyron vv.li...@wanadoo.fr wrote: You can also use a private attribute in connect_cached.new to tell the connected callback to do its thing: my $cb = { 'connect_cached.new' = sub {

Re: utf8 and mysql

On Thu, Aug 01, 2013 at 10:28:41AM +0300, Gabor Szabo wrote: On Wed, Jul 31, 2013 at 7:39 PM, Meir Guttman m...@guttman.co.il wrote: Dear Gabor, You must include «mysql_enable_utf8 = 1» hash record in the connection attributes used when you create the DBI handle my %conn_attrs =

Announce DBI 1.628

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.628.tar.gz size: 586733 bytes md5: 4273f8cc6ee3979ce448c7eb3f8a6a5a =head2 Changes in DBI 1.628 - 22nd July 2013 Fixed missing fields on partial insert via DBI::DBD::SqlEngine engines (DBD::CSV, DBD::DBM etc.) [H.Merijn Brand, Jens

Re: DBI Driver.xst and DBD::cego

Hi Kurt. On Sun, May 26, 2013 at 08:13:58PM +0200, Kurt Jaeger wrote: https://rt.cpan.org/Ticket/Display.html?id=84285 error: invalid conversion from 'const char*' to 'char*' I'm surprised the compiler treats this as an error, it's normally a warning. -char *plural =

ANNOUNCE DBI-1.627

Changes in DBI 1.627 - 16th May 2013 Fixed VERSION regression in DBI::SQL::Nano [Tim Bunce] =head2 Changes in DBI 1.626 - 15th May 2013 Fixed pod text/link was reversed in a few cases RT#85168 [H.Merijn Brand] Handle aliasing of STORE'd attributes in DBI::DBD::SqlEngine

Re: Huh? 4=3?

On Wed, May 08, 2013 at 10:58:02AM -0700, fe...@crowfix.com wrote: On Wed, May 08, 2013 at 09:43:27AM -0700, Bill Ward wrote: Cool. That whole scalar vs list context thing is one of Perl's biggest strengths, but also one of its biggest weaknesses (in that it is a common source of bugs like

Re: Relevance of ChildHandles

On Tue, May 07, 2013 at 10:28:29PM +0100, Alberto Simões wrote: Hello Any kind of handle on DBI has a $h-{ChildHandles} that store weakrefs to all child handles created. For instance, on a $dbh, you will get a list of weakrefs to $sth you create. When one of those $sth gets

Re: DBI Threaded use access?

On Wed, Oct 10, 2012 at 06:32:54PM -0700, Chris Buxton wrote: On Oct 10, 2012, at 1:21 PM, Jack Craig wrote: Hi DBI-Users, I have a simple Perl program to open a file, db, serially read file, write file records to db, close db, close file. if, between the db open close, given a

(Fwd) DBD::Oracle Continuous Query Notification

- Forwarded message from Rune Henssel rune.hens...@trapezegroup.eu - Date: Tue, 28 Aug 2012 13:03:08 +0200 From: Rune Henssel rune.hens...@trapezegroup.eu To: t...@cpan.org Subject: DBD::Oracle Continuous Query Notification Hi Tim I hope that you might be able to help me with a

Re: make test hangs when re-installing DBI under 64-bit

On Mon, Aug 20, 2012 at 08:41:45AM -0600, Harry Jamieson wrote: Environment: IBM AIX 5.3. Perl 5.8.8 now linked to its 64-bit libraries. 64-bit compiled test simple 0.98 64-bit compiled MakeMaker 6.48. We didn't discover that IBM had shipped our AIX with Perl pointed to the 32-bit version

Re: make test hangs when re-installing DBI under 64-bit

On Mon, Aug 27, 2012 at 01:42:20PM -0600, Harry Jamieson wrote: On 8/27/2012 12:07 PM, Tim Bunce wrote: On Mon, Aug 20, 2012 at 08:41:45AM -0600, Harry Jamieson wrote: Environment: IBM AIX 5.3. Perl 5.8.8 now linked to its 64-bit libraries. 64-bit compiled test simple 0.98 64-bit compiled

ANNOUNCE: DBI 1.622

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.622.tar.gz size: 585651 bytes md5: 9836bcf1b9acc842089aa10b16736909 =head2 Changes in DBI 1.622 (svn r15327) 6th June 2012 Fixed lack of =encoding in non-ASCII pod docs. RT#77588 Corrected typo in DBI::ProfileDumper thanks to Finn Hakansson.

Re: Odd error using bind_param_inout

I wonder if it would be possible (and useful) for DBD::Oracle to warn if there are unbound params. Tim. On Mon, Jun 04, 2012 at 02:12:53PM -0400, Jeffrey Seger wrote: $dbh-do() executes your sql. You are binding the parameter after this. Use $dbh-prepare instead. On Mon, Jun 4, 2012 at

Re: Installing 32 bit DBI.pm

On Fri, May 25, 2012 at 03:52:05PM +, chee.yuen...@accenture.com wrote: Hi, We are using a 32 bit perl 5.8.0 = ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), for GNU/Linux 2.2.5, not stripped As per your support

ANNOUNCE: DBI 1.621

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.621.tar.gz size: 585080 bytes md5: f44d84f8bdbabc14839eae0bd37e5509 =head2 Changes in DBI 1.621 (svn r15315) 21st May 2012 Fixed segmentation fault when a thread is created from within another thread RT#77137, thanks to Dave Mitchell. Updated

Re: Segfault in threaded program after upgrade to DBI 1.620

Ah, great. Thanks Matt. [Note to self: It's worth checking the bug tracker for updates from users.] DBI 1.621 is on it's way. Tim. On Mon, May 21, 2012 at 10:23:44AM -0500, Matthew Musgrove wrote: Tim, Yes, I updated that bug report last week to report that the patch worked for me.

ANNOUNCE DBI 1.620

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.620.tar.gz size: 584922 bytes md5: 2dfcff5b3b7afc53be402ef5f133da00 =head2 Changes in DBI 1.620 (svn r15300) 25th April 2012 Modified column renaming in fetchall_arrayref, added in 1.619, to work on column index numbers not names (an

ANNOUNCE DBI 1.618

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.618.tar.gz size: 583067 bytes md5: 5ad29b56f7457f22bd1ca1c871b30719 =head2 Changes in DBI 1.618 (svn r15170) 25rd February 2012 Fixed compiler warnings in Driver_xst.h (Martin J. Evans) Fixed compiler warning in DBI.xs (H.Merijn Brand) Fixed

Re: New DBD::ODBC 1.34_3 development release

On Fri, Feb 03, 2012 at 08:51:10PM +, Martin J. Evans wrote: You should also be aware that calling odbc_getdiag* will clear DBI's err, errstr and state so if you want DBI's methods to return something meaningful you may need to call them first - I'm unsure if I can stop this behaviour.

Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh

I'm late to this thread (it went into a different mail folder). Lyle, have you see the Oracle::OCI module? It provides deep integration between Oracle::OCI and DBD::Oracle. To make that possible I added a get_oci_handle function pointer to DBD::Oracle's handles. It lets you ask for any kind of

Re: DBD-Oracle - obtaining OCI handles from $dbh

On Fri, Oct 28, 2011 at 05:19:33PM +0100, Martin J. Evans wrote: On 28/10/2011 16:34, Charles Jardine wrote: I still use Oracle::OCI. There is a patch below which may allow you to build it under Oracle 11.2. As you will see, I have kept it going by botching things. Whenever a new feature of

Re: DBD-Oracle - obtaining OCI handles from $dbh

On Fri, Oct 28, 2011 at 11:09:20AM -0400, Lyle Brooks wrote: The only other comment I have on that approach is that the� interface comes out looking very C-like...meaning, the Perl interface looks almost like the OCI C interface, which is not too surprising. I found myself wishing that

Re: Oracle and Two Phase commit with Perl?

On Thu, Oct 06, 2011 at 03:20:08PM -0700, Eirik Toft wrote: On Sep 13, 11:16 am, mark.bo...@proquest.com (Bobak, Mark) wrote: Does anyone have any experience w/ doing two-phase commit across connections to two different databases from the same Perl program?  (To guarantee that either both

Re: Quoting of values in arrays in broken in DBD::Pg, can you help fix it? ( CPAN RT#58552 ) [SumsaultRT #9386]

On Fri, Sep 30, 2011 at 08:40:33AM -0400, Mark Stosberg wrote: Hello, If you use DBD::Pg and also use PostgreSQL arrays, you should be aware there is an open bug with quoting works. A bug report about the issue is here, including some related test cases and work on some patches:

Re: Tail Module + DBI Module, can\'t keep up!

This is all fine advice for performance tuning DBI app and worth doing. But there's always a limit to what can be achieved on the client. So it's worth exploring what can be done on the server side, beyond standard tuning practices. I wrote a high volume log insertion app using mysql many years

Re: Fwd: Idea for a Gofer transport for translating SQL - primarily intended for testing

On Sun, Sep 11, 2011 at 11:25:20PM +0100, Andrew Ford wrote: I suggest that we move this discussion to dbi-dev. [dbi-users dropped] On 11/09/11 18:14, Tim Bunce wrote: On Fri, Sep 09, 2011 at 03:50:53PM +0100, Andrew Ford wrote: my $next_middleware = $go_transport-middleware

Re: Fwd: Idea for a Gofer transport for translating SQL - primarily intended for testing

On Fri, Sep 09, 2011 at 03:50:53PM +0100, Andrew Ford wrote: Currently DBD::Gofer::dr:connect() contains code to set up the transport: my $transport_class = delete $go_attr{go_transport} or return $drh-set_err($DBI::stderr, No transport argument in '$orig_dsn');

Re: Fwd: Idea for a Gofer transport for translating SQL - primarily intended for testing

On Thu, Sep 08, 2011 at 01:19:17PM +0100, Andrew Ford wrote: Hi Tim Sorry for mailing you directly, but I don't know whether my emails are getting through to the dbi-users mailing list, [CC'd to dbi-users] and I would quite like to get this module onto CPAN and would like some

(Fwd) Sybase 15.0

- Forwarded message from Mackin, Thomas E. thomas.mac...@lfg.com - Date: Fri, 19 Aug 2011 14:33:11 -0400 From: Mackin, Thomas E. thomas.mac...@lfg.com To: tim.bu...@pobox.com Subject: Sybase 15.0 Tim, We migrated our Sybase database (AIX) to 15.0.2 about 2 years ago. We also

(Fwd) Question about DBD::Oracle

- Forwarded message from Sumiya sumiy...@tradewintech.co.jp - Date: Wed, 16 Mar 2011 09:19:15 +0900 From: Sumiya sumiy...@tradewintech.co.jp To: tim.bu...@pobox.com Subject: Question about DBD::Oracle Dear Mr. Tim Bunce, I would like to ask you about DBD::Oracle. Would you tell me what

(Fwd) Re: DBD::Oracle Slow cursors

- Forwarded message from P S Jameel Ahamed jaha...@idexcel.com - Date: Tue, 17 May 2011 16:11:04 +0100 From: P S Jameel Ahamed jaha...@idexcel.com To: tim.bu...@pobox.com Subject: Re: DBD::Oracle Slow cursors X-Mailer: Microsoft Office Outlook 11 HI Tim, We are facing huge

Re: Decoding data from the database in DBD

On Tue, May 10, 2011 at 08:01:02PM +0100, Martin J. Evans wrote: o returning the data in some native codepage like windows-1252 does not help you really, it probably hinders you and in any case you can encode it as windows-1252 afterwards when you output it somewhere. As a result, I think

(Fwd) Perl DBI on Mac OS X

- Forwarded message from david_st...@mcafee.com - Date: Mon, 2 May 2011 18:40:11 -0700 From: david_st...@mcafee.com To: tim.bu...@pobox.com Subject: Perl DBI on Mac OS X Hi Tim, Sorry to bother you. I am new to Perl DBI. I have it working fine on my Windows 7 box. I have

Re: General DBI spec Question?

[redirected to dbi-users list] On Fri, Apr 15, 2011 at 03:05:59PM -0400, John Scoles wrote: I was given a patch for DBD::Oracle today the just of it was to open up the OCI commands for starting up and shuting down the DB. So the question is would this be out of the DBI spec to allow direct

Re: Problem: given a dbh, extract the original args passed to connect()

On Thu, Apr 07, 2011 at 10:21:49AM -0700, Quinn Weaver wrote: Hi, I'm working on a new feature for David E. Wheeler's DBIx::Connector module. I want to make it so that if you pass an an existing dbh to the constructor, you get back a DBIx::Connector object that wraps the dbh.

  1   2   3   4   5   6   7   8   9   10   >