Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import cx_Oracle
- dsnStr=cx_Oracle.makedsn("helppls.pl.phub.com","2137","gang")
- con=cx_Oracle.connect(user='niewiem', password='comamzrobic', 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': 603501})
- for line in cur:
- print(line)
- cstat(603501)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement