########################################
# example of portable database API usage
########################################

from dcoracle import Connect
connobj = Connect("user/password@system")
cursobj = connobj.cursor()

value1,value2 ='developer', 40
query = 'SELECT name, shoesize FROM empl WHERE job = ? AND age = ?'

cursobj.execute(query, (value1, value2))
results = cursobj.fetchall()
for (name, size) in results:
    print name, size