python 调用oracle 存储过程 监控表空间(一 ) 是对oracle 数据库和存储过程进行配置,接下来看python 调用存储过程
import cx_Oracle as cx
# 用户名,密码,tns
user = 'test'
password = 'test'
host = '192.168.186.120'
port = '1521'
sid = 'orcl'
dsn = cx.makedsn(host, port, sid)
#con = cx.connect( user, password,tns)
con = cx.connect(user, password, dsn)
# 打开游标
curs = con.cursor()
#调用存储过程
curs.callproc('p_alert_log_db_tablespace', ('20160714', 'TEST', None, None))
# 关闭连接
curs.close()
con.close()