cx_oracle and commands

gaius hammond gaius at
Fri Sep 5 15:26:04 CEST 2008

Hi all,

I am having a very strange problem with cx_Oracle, has anyone seen this kind of behavior before:

ActivePython (ActiveState Software Inc.) based on
Python 2.5.2 (r252:60911, Mar 27 2008, 18:53:24) [C] on sunos5
Type "help", "copyright", "credits" or "license" for more information.
>>> from commands import getstatusoutput
>>> (status, output) = getstatusoutput('ls')
>>> status
>>> from cx_Oracle import connect, SYSDBA
>>> db = connect(mode=SYSDBA)
>>> (status, output) = getstatusoutput('ls')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/opt/ASpy25/lib/python2.5/", line 55, in getstatusoutput
    sts = pipe.close()
IOError: [Errno 10] No child processes

Basically, once I have made a connection to Oracle I can no longer use getstatusoutput(). This is a real problem as
I need to get a list of things to work on from Oracle then spawn commands to process them...



gaius at

"First things first, but not necessarily in that order" -- The 
Doctor, "Doctor Who" 

Visit Pipex Business: The homepage for UK Small Businesses

Go to

More information about the Python-list mailing list