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

2009-12-15 Thread Peter J. Holzer
On 2009-12-14 07:18:41 -0500, jeff wrote: I need to connect simultaneously to both Oracle 8 and oracle 10 from the same script using 'external' connection (ie, no username or password). The Oracle libraries, from my experimentations, are not compatible for external connections. Oracle 8 uses

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

2009-12-15 Thread jeff
Just reading about RMI - sounds promising :-) Thanks you very much. On Mon, 2009-12-14 at 20:09 -0600, Scott Smith wrote: 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

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

2009-12-15 Thread jeff
Scott, Would something like this be close: ## $c = RMI::Client::ForkedPipes-new(); $c-call_use_lib($ENV{MY_PERL_INSTALL}.'/some/path/to/other/Oracle_module'); # A build of Oracle DBD using oracle 8 client not normally in @INC $c-call_use('DBI');

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: data retrieved from database is unexpectedly tainted

2009-12-15 Thread Martin Evans
Martin J. Evans wrote: Martin J. Evans wrote: Hi, I've spent some time on this today and I am getting nowhere. Before I redouble my efforts I thought I'd post here just in case anything rings a bell with someone. We are using the latest DBI and DBD::Oracle to get data from an Oracle data.

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

2009-12-15 Thread jeff
Thank you, Scott ! In case anyone else needs this sort of setup: I wanted to share this quick dirty successful test using Scott's RMI to connect to both oracle 10 with a wallet and oracle 8 with external authentication - no user names or passwords provided in script. ora8_lib contains the

Re: data retrieved from database is unexpectedly tainted

2009-12-15 Thread Tim Bunce
On Tue, Dec 15, 2009 at 02:53:03PM +, Martin Evans wrote: If you are using the latest DBI and Perl 5.10.0 or 5.10.1 and running in taint mode (but have not set DBI's Taint, TainTIn, TaintOut) then use tainted strings in the SQL you issue the resulting data is tainted. All we were doing is

Re: data retrieved from database is unexpectedly tainted

2009-12-15 Thread Martin Evans
Tim Bunce wrote: On Tue, Dec 15, 2009 at 02:53:03PM +, Martin Evans wrote: If you are using the latest DBI and Perl 5.10.0 or 5.10.1 and running in taint mode (but have not set DBI's Taint, TainTIn, TaintOut) then use tainted strings in the SQL you issue the resulting data is tainted. All

Re: Help saving MySQL

2009-12-15 Thread Mike Howard
So, how do we write to the Eurpoean Commission? Do they have an address? Tim Bunce wrote: Michael “Monty” Widenius, the creator of MySQL, has asked me, among many others, to help spread the word about an imminent decision by the European Commission on the Oracle merger with Sun. Why should you

RE: DBD::DB2 on Windows with Strawberry Perl

2009-12-15 Thread Thakore, Kartik
I have managed to get DBD::DB2 using the ppm install. But now when I use: I get this error. H:\perl db2.pl Your vendor has not defined DBD::DB2::Constants macro SQL_PARAM_INPUT_OUTPUT at C:/strawberry/perl/site/lib/DBD/DB2.pm line 40 Compilation failed in require at db2.pl line 3. BEGIN

Re: Help saving MySQL

2009-12-15 Thread Tim Bunce
On Tue, Dec 15, 2009 at 07:06:50AM -0700, Mike Howard wrote: So, how do we write to the Eurpoean Commission? Do they have an address? In Monty's post he says: Send this to: comp-merger-regis...@ec.europa.eu If you want to keep us updated, send a copy to e...@askmonty.org Tim. Tim

Re: data retrieved from database is unexpectedly tainted

2009-12-15 Thread Tim Bunce
On Tue, Dec 15, 2009 at 04:17:42PM +, Martin Evans wrote: I've no idea what is tainting the returned data but this is reproducible for us here is a small amount of perl. From memory, perl tainting works on a per-statement basis. If a tainted value is accessed during a statement

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

2009-12-15 Thread Scott Smith
Great. Glad it works for you! jeff wrote: Thank you, Scott ! In case anyone else needs this sort of setup: I wanted to share this quick dirty successful test using Scott's RMI to connect to both oracle 10 with a wallet and oracle 8 with external authentication - no user names or passwords