Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #97245 > unrolled thread

Oracle connect

Back to article view | Back to comp.lang.python

Contents

  Oracle connect pip7kids@gmail.com - 2015-09-30 08:25 -0700
    Re: Oracle connect Larry Martell <larry.martell@gmail.com> - 2015-09-30 11:34 -0400

#97245 — Oracle connect

Hi 
New to Python and just downloaded 3.5
Trying to connect to Oracle but failing - eg

import cx_oracle
connstr = 'userid/password@@99.999.9.99:PORT/SID' 
connection = cx_oracle.connect(connstr)                   
cursor = connection.cursor()                              
cursor.execute("SELECT * FROM MYTABLE WHERE ROWNUM <=100")
cursor.close()
connection.close()

Getting error No module named 'cx_oracle'

Any examples or should I use an earlier version of Python.

Regards

[toc] | [next] | [standalone]

#97246

On Wed, Sep 30, 2015 at 11:25 AM,  <pip7kids@gmail.com> wrote:
> Hi
> New to Python and just downloaded 3.5
> Trying to connect to Oracle but failing - eg
>
> import cx_oracle
> connstr = 'userid/password@@99.999.9.99:PORT/SID'
> connection = cx_oracle.connect(connstr)
> cursor = connection.cursor()
> cursor.execute("SELECT * FROM MYTABLE WHERE ROWNUM <=100")
> cursor.close()
> connection.close()
>
> Getting error No module named 'cx_oracle'

Did you install cx_oracle? If not, do this:

pip install cx_Oracle

Also, there is a cx_oracle mailing list.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web