RE: Error always returned from system() after connecting to Oracl e10 .2 on Solaris 64 bit
am 09.11.2007 12:56:58 von peter.sands------_=_NextPart_001_01C822C7.038FAB8A
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thanks, you're right. I have a local database and am using the bequeath
server to login; changing to use a network connect as you suggest avoids the
problem.
Aaron Saarela at Symantec suggested I add $SIG{ CHLD } = 'DEFAULT'; after
the Oracle connect to restore the default sig handler; this also corrects
it.
Peter Sands
-----Original Message-----
From: Charles Jardine [mailto:cj10@cam.ac.uk]
Sent: 09 November 2007 10:53
To: Sands Peter
Cc: 'dbi-users@perl.org'
Subject: Re: Error always returned from system() after connecting to Oracle
10 .2 on Solaris 64 bit
On 07/11/07 13:31, Sands Peter wrote:
> Running perl5.8.3 compiled 32 bit with the Perl libraries, DBD 1.15,
> DBI
> 1.41 distributed with Oracle 10.2, I find that, having connected to
> Oracle within a perl script any subsequent system() calls return a -1
> error status, even simple commands like true. (First tried building
> and using DBD-Oracle-1.19, DBI-1.40 with the same results).
I think it likely that this is something to do with Oracle's handling of
SIGCHLD. I have a hunch that this might only happen if the connection is not
via Oracle*Net.
Is you database local? Are you connecting using the bequeather?
--
Charles Jardine - Computing Service, University of Cambridge
cj10@cam.ac.uk Tel: +44 1223 334506, Fax: +44 1223 334679
|* This e-mail, and any attachments, is confidential and for the use of the addressee only.
|* If you are not the intended recipient, please telephone +44 (0) 1506 408700
|* We do not accept legal responsibility for this e-mail or any viruses.
|* All e-mails sent and received by us are monitored.
|* Contracts cannot be concluded with us by e-mail.
|* This message has been sent from a member of the British Energy Group (the "Group").
|* The parent company of the Group is British Energy Group plc, a company registered in Scotland, registered number 270184, and having its registered office at
|* Systems House, Alba Campus, Livingston EH54 7EG
------_=_NextPart_001_01C822C7.038FAB8A--