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
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
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');
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
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.
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
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
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
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
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
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
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
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
13 matches
Mail list logo