On Thu, 16 May 2002 12:07:10 -0600 Rebecca Louden <[EMAIL PROTECTED]> wrote:
> 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? Sure. But they each need their own database connection. Sometimes those can be cached like Apache::DBI, but I haven't used that functionality. If you are trying to process large datasets in parallel, bringing the data back to the parent may be a bit of a problem due to pipe bandwidh, so I normally have had child processes write their output to files and had the parent merge the results. > -----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.
