import cx_Oracle
def cstat(mnr):

    dsnStr=cx_Oracle.makedsn("fd.pl.fds.com","2317","Hf1")
    con=cx_Oracle.connect(user='lg', password='pswd', dsn=dsnStr)
    cur=con.cursor()



    cur.execute("""SELECT DISTINCT M_STATUS, STOER_TEXT
    FROM HYDADM.MASCHINEN_STATUS INNER JOIN
    (HYDADM.STOER_TABELLE INNER JOIN HYDADM.STOERTEXTE ON HYDADM.STOER_TABELLE.STOERTXT_NR = HYDADM.STOERTEXTE.STOERTXT_NR)
    ON HYDADM.MASCHINEN_STATUS.M_STATUS = HYDADM.STOER_TABELLE.STOERNR
    WHERE HYDADM.MASCHINEN_STATUS.MASCH_NR = :id""",{'id': mnr})

    for line in cur
    return("mnr")

print(cstat(603501))