Although this may create up more problems than it solves, but I did something similar to what you are talking about, albeit in Java. There I used different threads in the same process to execute stored procedures, all across the same database connection. Oracle didn't seem to mind a bit. But even then, only one sql statement would be executing at a time. But concurrency issues with threads can be very tricky, even if you do know what you are doing.
Michael A
Chase To: Becka <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
<[EMAIL PROTECTED] cc:
com.com> Subject: Re: fork and DBI on Win 2000
05/16/02 02:13
PM
Please respond
to Michael A
Chase
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.
