cx_Oracle function to return sql result into Python var

epipko

db.py

--------------

def connect(db):    """ Connect to the database """    try:        # dsn = cx_Oracle.makedsn(host='MYHOST', sid='DEVPRON', port=1521)        conn = cx_Oracle.connect(user = dbconfig._USER, password = dbconfig._PWD, dsn = db)    except cx_Oracle.Error as error:        raise error    else:        cur = conn.cursor()            return conn, cur

def execute(conn, cur, sql, bindvars=None, commit=False):    """    Execute whatever SQL statements are passed to the method;    commit if specified. Do not specify fetchall() in here as    the SQL statement may not be a select.    bindvars is a dictionary of variables you pass to execute.    """    try:        cur.execute(sql, bindvars)     except cx_Oracle.DatabaseError as e:        raise e    if commit:        cur.commit()

main.py

----------

conn, cur = db.connect('TITAN')

sql = ("""  select max(id) order_id from orders """)

How do I return result of select into a variable in Python ???

max_order_id = db.execute(conn, cur, sql)

Christopher Jones-Oracle

You'll have to 'know' that you are executing a SELECT and then call fetchone() or similar

In shorthand:

(c_id,) = connection.cursor().execute("select 123 from dual").fetchone()

print(c_id)

You will find the cx_Oracle samples useful: https://github.com/oracle/python-cx_Oracle/tree/master/samples

And the doc has a lot of interesting reading: https://cx-oracle.readthedocs.io/en/latest/user_guide/introduction.html