import cx_Oracle

import threading

import db_config

pool = cx_Oracle.SessionPool(db_config.user, db_config.pw, db_config.dsn,

min = 2, max = 5, increment = 1, threaded = True,

getmode = cx_Oracle.SPOOL_ATTRVAL_WAIT)

def Query():

print("Thread", threading.current_thread().name, "fetched sequence =", seqval)

numberOfThreads = 2

threadArray = []

for i in range(numberOfThreads):

thread = threading.Thread(name = '#' + str(i), target = Query)

threadArray.append(thread)

thread.start()

for t in threadArray:

t.join()

print("All done!")