Actually, it's not impossible at all. However, the way you need to do it
is to pass the connect string or instance name for the database to your
child process and let the child process create its own connection, rather
than passing the already created connection to the child. You wind up with
a lot more connections this way, but unless you are updating or inserting,
this shouldn't be a problem. If you are updating or inserting, you need to
be concerned with making certain that any process modifying a table
completes before another one starts, etc...
We actually have an application that runs our entire data warehouse load
process this way.
*******************************
Jeff Seger
Data Warehouse Engineer
Fairchild Semiconductor
[EMAIL PROTECTED]
*******************************
Rebecca Louden
<RLouden@collectam To: "'Michael A Chase'"
<[EMAIL PROTECTED]>,
erica.com> [EMAIL PROTECTED]
cc:
05/16/2002 02:07 Subject: RE: fork and DBI on Win 2000
PM
Uh oh. Then is what I want to do possible at all? Is there no way to
launch several SQL scripts at the same time, using a Perl script?
Thanks,
Becka
-----Original Message-----
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 12:13 PM
To: Becka; [EMAIL PROTECTED]
Subject: Re: fork and DBI on Win 2000
On 16 May 2002 16:29:33 -0000 Becka <[EMAIL PROTECTED]> wrote:
> I am missing out on a concept, I hope someone can help. (I'm getting an
access
> violation when I run my script.) What I want to do is write a script
that
> connects to the database, forks several processes (which will actually be
> executions of prepared statements, which call SQL scripts), and then
exits. My
> entire goal is to run several executions simultaneously.
Oracle does not allow parents and children to share database connections.
As a result the behavior of DBD::Oracle when you try to do it is often
unpleasent.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
