for one child, you can pass it
once you've done dbh->{InactiveDestroy}=1; inside the parent
and when it ends, the same connexion can be used from the parent.
But for many children, I tried to disconnect inside the parent,
and connect/disconnect inside kids,
and back to parent when kids end, connect again .. and disconnect !
but the first child says DBD::Oracle::db prepare failed: ERROR Database disconnected
no way through IPC:Shareable with lock/unlock (mutex...)?
" L. Trindle Gennari" <[EMAIL PROTECTED]> wrote:
>The child has to make and break the connection. You can't pass it from parent to
>child. What I do is not have the parent connect at all, just leave it to the kids....
>
>ltg
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 30, 2004 9:11 AM
>To: [EMAIL PROTECTED]
>Subject: fork and keeping connection DBD::Oracle ?
>
>Hello,
>from main perl
>connect,
>forking n kids and waiting for them to end with their prepare/execute sth
>back to parent
>and disconnect
>gives
>DBD::Oracle::db disconnect failed: ORA-03113: end-of-file on communication channel
>(DBD ERROR: OCISessionEnd)
>
>even if I reconnect inside kids,
>
>do $ENV{ORAPIPES} or ora_dbh_share deal about ?
>
>please help !!
>
>
__________________________________________________________________
Switch to the New Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
