Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core

Looking at the DBD::Oracle documentation, I wonder whether the problem isn't caused by the fact that you're setting up the connection inside the thread.

Have you tried running this:

my $dbh = DBI->connect("dbi:Oracle:host=localhost;sid=testdb1", "user1
+", "pass1", 
+{ ora_dbh_share => \$orashr} ) || die $!;
[download]

in the main thread before you start the other threads? $dbh should be cloned to each thread automatically (and probably correctly) because the ora_dbh_share attribute was set.

Liz

Comment on Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core Select or Download Code

Replies are listed 'Best First'.
Re: Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core by fx (Pilgrim) on Dec 21, 2003 at 15:45 UTC
I have just tried this - the program now dumps core before starting any threads. I don't even get the `Starting thread` message that should appear before the first `new threads` is called. The core file is now only 2.5Mb whereas it used to be upwards of 10Mb but I suppose that is because there are no threads to increase the size of the core file. Thanks for the advice all the same.	[reply]