Connect.py not working -

[ravi2948]

I wrote a connect.py script to execute in Python version 2.7 in our server. it's throwing an error below
NameError: name 'connect' is not defined

Script (Connect.py)

import cx_Oracle
import print_function
import sys
import db_config
conn_str='user/password@XXXd'
try:
    conn = cx_Oracle.connect(conn_str)
        c=conn.cursor()
        c.execute('select * from table where rownum < 10')
        for row in c:
    print(row)
conn.close()
except Exception as e:
    print(e)

output

>>> connect.py
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
NameError: name 'connect' is not defined

Environment: Exadata Oracle DB 12c.

Client : Oracle 12.2 (64-bit)
Linux version: RHEL 7.1

[anthony-tuininga]

Hi, if you want to run the Python script you should use the following:

python connect.py

If you want to run the file interactively you need to do this instead:

execfile("connect.py")

[anthony-tuininga]

I assume based on the lack of a response that your question has been answered. If not, please re-open!