import cx_Oracle
def cstat(mnr):

    dsnStr=cx_Oracle.makedsn("fd.pl.fds.com","1521","HYD1")
    con=cx_Oracle.connect(user='fds', password='fd', 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:
        wynik=line
    return(line)

print(cstat(603501))