Oracle connect

Larry Martell larry.martell at gmail.com
Wed Sep 30 11:34:50 EDT 2015


On Wed, Sep 30, 2015 at 11:25 AM,  <pip7kids at 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.



More information about the Python-list mailing list