Maintaining simultaneous support for two Oracle versions in DBI

2011-12-03 Thread Scott Smith
should have included? Thanks for any help, Scott Smith

Re: Looking for clever solution: Different versions of Oracle .so files within single Perl build

2009-12-15 Thread Scott Smith
Try RMI::Client::ForkedPipes. Have the child process use one lib, and the parent use the other. The child can give back with one DBI/DBD, and the parent can produce handles from the other. This is effectively the proxy solution, but you're just forking and proxying to a private sub-process

Re: Success ! Different versions of Oracle .so files within single Perl build

2009-12-15 Thread Scott Smith
OK :) Oracle8\n; } else { print No Connection Oracle8\n; } $remote_dbh-disconnect; On Mon, 2009-12-14 at 20:09 -0600, Scott Smith wrote: Try RMI::Client::ForkedPipes. Have the child

Re: NULL = undef, even in Perl list?

2009-03-10 Thread Scott Smith
Hi Brian, What was the return value of execute()? Was there a DBI error message set afterward? ($sth_upd[$_]-errstr) You're right that passing undef should work just fine as one of the execution params should translate into a NULL on the database side. Yeah, as long as it's in the 1st or

Re: How to iterate through database tables

2009-02-03 Thread Scott Smith
I think his issue is getting list to the server side without concatenating strings. You can't use bind variables as table names or column names. You may be able to write a stored procedure which takes a table name as a variable, does the string concatenation on the server side, and uses

Re: Proposal for new $h-{ReadOnly} attribute

2007-05-04 Thread Scott Smith
since your set trans.. statement with each query, and might result in a snapshot too old error. I don't know if/how other databases implement this feature, and give it such a possibly misleading name. Does anyone else? Scott Smith Tim Bunce wrote: I've just added this to the DBI docs

Re: Proposal for new $h-{ReadOnly} attribute

2007-05-04 Thread Scott Smith
Tim Bunce wrote: On Fri, May 04, 2007 at 08:15:53AM -0500, Scott Smith wrote: Doing set transaction read only on Oracle has additional side-effects besides making the connection unable to write: it switches the read consistency level from per-statement (the default) to per-transaction

Re: environment variable

2007-01-19 Thread Scott Smith
general shell session. i.e. LD_PRELOAD=/usr/lib/special_old_library.so /usr/bin/oldprogram Scott Smith Genome Sequencing Center

Re: [EMAIL PROTECTED]: elegent way to handle pluggable backend servers?]

2005-02-18 Thread Scott Smith
of fields passed-in and handle boolean values specially, for instance, in a generic way. We use these and actual queries to the data dictionary of the given database to make the SQL writer smart. Scott Smith Informatics Genome Sequencing Center Washington University School of Medicine David Dooling wrote

Identifying .mk files, building

2002-10-16 Thread Scott Smith
but make didn't work and there were some strange things in the makefile. Please reply personally. Scott Smith NYS Task Force on Reapportionment _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com