Trying to install cx_Oracle

[Paulmiddleton]

I'm new to Python and would like to learn it but also want to use cx_Oracle to access Oracle. I've installed 2 versions of Python and on the latest version (3.1.2) I get the error

File "<stdin>", line 1
install cx_Oracle
^
SyntaxError: invalid syntax

Please Help
I've put the cx_Oracle in the local dirctory and the path to it in the path. I'm using windows

[bvdet]

If you did a binary installation, all you need to do is import the module as in:

import cx_Oracle

[Paulmiddleton]

Thanks but thats what I do and then I get the error

[bvdet]

I could be something as simple as a leading space character as in:

>>>  import math
Traceback (  File "<interactive input>", line 1
    import math
    ^
SyntaxError: invalid syntax
>>> 

[Paulmiddleton]

Unfortunately not, I've tried extra spaces, upper case, lower case, the case that is specified...... AAAAAggggh

[bvdet]

It's probably something in the preceding code, possibly unbalanced parentheses.

[Paulmiddleton]

but I'm only putting in import cx_Oracle

[bvdet]

@Paulmiddleton
Does this work:

import math

[Paulmiddleton]

That worked, just went straight back to the prompt

[Paulmiddleton]

>>> import cx_Oracle
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: DLL load failed: The specified module could not be found.

[bvdet]

Make sure the pyd file is in a directory on the Python path as in:

>>> import sys
>>> sys.path

[Paulmiddleton]

This is the results of the above, I've put the cx_Oracle.pyd file in every directory here but still get the asme error. How do I add a directory to sys??

['', 'C:\\Python31\\python31.zip', 'C:\\Python31\\DLLs', 'C:\\Python31\\lib', 'C:\\Python31\\lib\\pl
at-win', 'C:\\Python31', 'C:\\Python31\\lib\\site-packages']

Error Message


>>> import cx_Oracle
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: DLL load failed: The specified module could not be found.

[bvdet]

@Paulmiddleton
Did you perform a binary installation? The install file should have a name like cx_Oracle-5.0.3-10g.win32-py2.6.msi.

[Paulmiddleton]

Yes,the install file is
cx_Oracle-5.0-10g.win32-py3.0.msi

[bvdet]

Try installing the version that matches your Python version:
cx_Oracle-5.0.3-10g.win32-py3.1.msi

[Paulmiddleton]

I've now installed that version and I still get the same error. How does it know about the directory its installed in? or what directory should I put the file in?

[bvdet]

I have never installed this module. Typically installs such as this look for a Python installation in your registry and will put the required files in a folder under lib/site-packages. For example, on my system PIL was installed in 'C:\\Python23\\lib\\site-packages\\PIL' and that folder was added to the Python path.

[Paulmiddleton]

ah well, thanks for your help, I'm loosing the will to live.
with python31, I've just tried print "Hello" and got the following message
File "<stdin>", line 1
print "Hello"
^
SyntaxError: invalid syntax

but it is ok when I do it in python24

[Paulmiddleton]

I have just re-installed python31 and still get an error when trying to print. 2+3 is ok but not print

[bvdet]

I wish I could be more help. I'm still in Python 2.3 because that's the version embedded in the software I use in my work.

[Paulmiddleton]

Yeah, that seems to work but I still get an error message when I do import cx_Oracle.

It maybe because I don't have any sys admin rights on this dammed PC. I'm going to give up. Thanks anyway for trying

[Michelle Lermon]

Paul,
I am having the same install problems with cx_Oracle but I have figured out the print issues. If you want to print hello in Python 3.1 you have to write the following:
print('hello')

that should work.

Michelle